![]() Previous |
![]() Next |
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
.