OraFAQ Forum: SQL & PL/SQL » Difference between sysdate , current date , current_timestamp and local

Home » SQL & PL/SQL » SQL & PL/SQL » Difference between sysdate , current date , current_timestamp and local_timestamp (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)

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

Difference between sysdate , current date , current_timestamp and local_timestamp [message #555986]

Wed, 30 May 2012 07:30

saipradyumn
Messages: 419
Registered: October 2011
Location: Hyderabad

Senior Member

Hi all

What is the difference between the following . In my schema all are giving the same results with some different format


SQL> SELECT sysdate , current_date , current_timestamp  , localtimestamp from dual;
 
SYSDATE     CURRENT_DATE CURRENT_TIMESTAMP                                 LOCALTIMESTAMP
----------- ------------ ------------------------------------------------- -------------------------------------------------
5/30/2012 8 5/30/2012 8: 30-MAY-12 08.27.22.037703 AM -04:00               30-MAY-12 08.27.22.037703 AM

Thanks
SaiPradyumn

Report message to a moderator