LOCALTIMESTAMP

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.