Home » SQL & PL/SQL » SQL & PL/SQL » current_date and sysdate (oracle 9i)
current_date and sysdate [message #388830] Thu, 26 February 2009 06:00 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
what is the diff between current_date and sysdate ?
Re: current_date and sysdate [message #388832 is a reply to message #388830] Thu, 26 February 2009 06:10 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CURRENT_DATE returns the current date in the session time zone, in a value in the Gregorian calendar of datatype DATE.

SYSDATE returns the current date and time set for the operating system on which the database resides.

Regards
Michel

[Updated on: Thu, 26 February 2009 06:10]

Report message to a moderator

Previous Topic: inconsistent datatype ora:00932
Next Topic: UNIX-Oracle Error
Goto Forum:
  


Current Time: Sat Dec 03 12:26:51 CST 2016

Total time taken to generate the page: 0.11084 seconds