Table of ContentsPreviousNext

Ispirer             Ispirer

Ispirer SQLWays Database Migration Software

SYSDATE

Syntax

SYSDATE

The SYSDATE function returns the current date and time.

Example

This example selects the current system date and time. 

SELECT SYSDATE
FROM dual;

Equivalents in other databases

TABLE 85. Equivalents in other databases
IBM DB2
CURRENT TIMESTAMP special register
Microsoft SQL Server
GETDATE function

Table of ContentsPreviousNext
Ispirer             Ispirer
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.