LOCALTIMESTAMP

The LOCALTIMESTAMP function returns the current date and time in the session time zone as a value of data type TIMESTAMP.

When you want to retrieve the current date and time in the session time zone as a TIMESTAMP_TZ value, use the CURRENT_TIMSTAMP function.

Return Values

TIMESTAMP

Syntax

LOCALTIMESTAMP [ (timestamp-precision) ]

ARGUMENTS

timestamp-precision: Specifies the fractional second precision of the time value returned

Examples

Retrieving the Local Timestamp

SHOW LOCALTIMESTAMP
13-FEB-07 12.11.33.454834 PM