![]() Previous |
![]() Next |
LOCALTIMESTAMP
returns the current date and time in the session time zone.
Return Value
TIMESTAMP
Syntax
LOCALTIMESTAMP [ (timestamp_precision) ]
Arguments
timestamp_precision
specifies the fractional second precision of the time value returned.
Examples
LOCALTIMESTAMP
returns a value such as 09-AUG-06 08.11.37.045186 AM
.
LOCALTIMESTAMP(2)
returns a value such as 09-AUG-06 08.11.37.040000 AM
.