Home » SQL & PL/SQL » SQL & PL/SQL » change sysdate
change sysdate [message #19090] Thu, 28 February 2002 00:50 Go to next message
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 #19091 is a reply to message #19090] Thu, 28 February 2002 01:18 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
why u want to do so ? is your sysdate is not giving u correct information ?can u explain little bit more
Re: change sysdate [message #19093 is a reply to message #19090] Thu, 28 February 2002 01:36 Go to previous messageGo to next message
THA
Messages: 26
Registered: February 2002
Junior Member
change the server date.
but isnt it funny to change the server date?
Re: change sysdate [message #19111 is a reply to message #19090] Thu, 28 February 2002 08:31 Go to previous message
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;
Previous Topic: Trigger firing when it shouldn't
Next Topic: not a single group function
Goto Forum:
  


Current Time: Fri Mar 29 00:30:58 CDT 2024