Home » RDBMS Server » Server Administration » Oracle Server date
Oracle Server date [message #295064] Mon, 21 January 2008 04:27 Go to next message
deepak samal
Messages: 29
Registered: February 2005
Junior Member

How can i check the oracle server date. Is it possible that i can change the oracle server date.

I think SysDate gives the system date.
select sysdate from dual; -- Gives the system date

so how can i get the oracle server date.

Please help me out.

thanks in advance
Re: Oracle Server date [message #295070 is a reply to message #295064] Mon, 21 January 2008 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From documentation: "SYSDATE returns the current date and time set for the operating system on which the database resides."
So this is server date.

Re: Oracle Server date [message #295071 is a reply to message #295064] Mon, 21 January 2008 04:39 Go to previous message
Messages: 93
Registered: February 2007
Location: Mumbai

Oracle takes date/time values from OS. Manipulate OS date /time if you desire.


Manjit Kumar [mkbhati]

Previous Topic: Flushing Shared Pool
Next Topic: disable parallelins at database level
Goto Forum:

Current Time: Wed Oct 26 07:14:10 CDT 2016

Total time taken to generate the page: 0.13156 seconds