LOCALTIMESTAMP – Oracle SQL Function

LOCALTIMESTAMP returns a TIMESTAMP value.

You can specify an optional integer argument to specfiy the precision of the second field.

Example:

SELECT LOCALTIMESTAMP FROM DUAL;

LOCALTIMESTAMP
—————————-
13-SEP-05 03.02.49.407000 PM