Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer Oracle to SQL Server Migration overview.

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