SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

systimestamp and current_timestamp

720232Jan 4 2010 — edited Sep 23 2011

Hi All

What is the difference between systimstamp and current_timetsamp?

When i executed ,

select systimestamp,current_timestamp from dual;

got result as

SYSTIMESTAMP CURRENT_TIMESTAMP
*04-JAN-10 07.57.31.048428000 AM -05:00 04-JAN-10 06.27.31.048504000 PM +05:30*

Please Clarify,

This post has been answered by Solomon Yakobson on Jan 4 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2011

Added on Jan 4 2010

#function, #oracle, #sql

6 comments

61,385 views