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_TIMESTAMP function.
Syntax
LOCALTIMESTAMP [ (timestamp-precision) ]
ARGUMENTS
- timestamp-precision
-
Specifies the fractional second precision of the time value returned
Examples
Example 8-13 Retrieving the Local Timestamp
SHOW LOCALTIMESTAMP
13-FEB-07 12.11.33.454834 PM
