OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Server date

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Server date [message #295064]

Mon, 21 January 2008 04:27

deepak samal
Messages: 29
Registered: February 2005

Junior Member

HI,

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
Deepak

Report message to a moderator

Re: Oracle Server date [message #295070 is a reply to message #295064]

Mon, 21 January 2008 04:36

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Regards
Michel

Report message to a moderator

Re: Oracle Server date [message #295071 is a reply to message #295064]

Mon, 21 January 2008 04:39

mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai

Member

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

Regards

Manjit Kumar [mkbhati]

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 21 16:16:20 CDT 2026