CURRENT TIMESTAMP

Syntax

CURRENT TIMESTAMP

The CURRENT TIMESTAMP special register specifies a timestamp that is based on a reading of time-of-day clock when the SQL statement is executed. If this special register is used more than once within a single SQL statement, all values are based on a single clock reading.

Example

This example inserts a row into the CUSTOMERS table. The value of the second column is a timestamp that indicates when the row was inserted.

INSERT INTO CUSTOMERS VALUES ('ABC Corp', CURRENT TIMESTAMP);

Equivalents in other databases

TABLE 69. Equivalents in other databases

Oracle	SYSDATE function
Microsoft SQL Server	GETDATE function