CURRENT TIMESTAMP Special Value

Combines CURRENT DATE and CURRENT TIME to form a TIMESTAMP value containing the year, month, day, hour, minute, second and fraction of a second.

As with CURRENT TIME, the accuracy of the fraction of a second is limited by the system clock.

CURRENT TIMESTAMP defaults to 3 digits.

Data type

TIMESTAMP

Related reference
TIMESTAMP Special Value
CURRENT TIME Special Value
CURRENT DATE Special Value
Date and Time Data Types
Retrieve Dates and Times
CURRENT USER Special Value
LAST USER Special Value
USER Special Value