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
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: 65144
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.


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

Report message to a moderator

Previous Topic: -SQL -Not starting
Next Topic: rownum grater than 1 (merged)
Goto Forum:

Current Time: Sat Aug 19 19:27:48 CDT 2017

Total time taken to generate the page: 0.30064 seconds