Oracle CURRENT_TIMESTAMP

Posted on 11/15/2011 by admin

Function Description

Function CURRENT_TIMESTAMP returns current date and time in the session time zone.

Examples

SELECT CURRENT_TIMESTAMP
  FROM dual 

Result: 29.8.2011 10:36:32,789650 +02:00

SELECT CURRENT_TIMESTAMP

FROM dual

Result: 29.8.2011 10:36:32,789650 +02:00

SELECT CURRENT_TIMESTAMP(1)
  FROM dual 

Result: 29.8.2011 10:40:30,8 +02:00

SELECT CURRENT_TIMESTAMP(1)

FROM dual

Result: 29.8.2011 10:40:30,8 +02:00

This entry was posted in Oracle SQL Functions. Bookmark the permalink.