change sysdate [message #19090] |
Thu, 28 February 2002 00:50 |
Manoj
Messages: 101 Registered: August 2000
|
Senior Member |
|
|
Hi,
pls, tell me how can i change sysdate in the database
thanx in advn.
|
|
|
|
|
Re: change sysdate [message #19111 is a reply to message #19090] |
Thu, 28 February 2002 08:31 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
Note that you can do timezone conversion too...
select to_char(sysdate, 'dd-Mon-yyyy hh24:mi:ss'),
to_char(new_time(sysdate,'PDT','GMT'), 'dd-Mon-yyyy hh24:mi:ss') from dual;
|
|
|