CURRENT_TIMESTAMP

The CURRENT_TIMESTAMP function returns the current date and time in the session time zone, as a value of data type TIMESTAMP_TZ. The time zone offset reflects the current local time of the session.

When you want to retrieve the current date and time in the session time zone as a TIMESTAMP value, use the LOCALTIMESTAMP function.

Return Values

TIMESTAMP_TZ

Syntax

CURRENT_TIMESTAMP [ (precision) ]

Arguments

precision: The fractional second precision of the time value returned. When you omit this argument, then the function uses a default value of 6.

Examples

Example 7-59 Retrieving the Current Timestamp

Assume you want to retrieve the current timestamp.

SHOW CURRENT_TIMESTAMP
13-FEB-07 09.11.33.454685 AM -08:00