CURRENT_TIMESTAMP

CURRENT_TIMESTAMP returns the current date and time in the session time zone. The time zone offset identifies the current local time of the session.

Return Value

TIMESTAMP WITH TIME ZONE

Syntax

CURRENT_TIMESTAMP [ (precision) ]

Arguments

precision specifies the fractional second precision of the returned time value. The default value is 6.

Examples

CURRENT_TIMESTAMP returns a value such as 08-AUG-06 11.18.31.082257 AM -08:00.

CURRENT_TIMESTAMP(2) returns a value such as 08-AUG-06 11.18.31.08 AM -08:00.