Ispirer SQLWays Database Migration Software

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 80. Equivalents in other databases

Oracle	SYSDATE function
Microsoft SQL Server	GETDATE function

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.