Returns the current date.

Syntax

TODAY( * )

Remarks

Use this syntax in place of the historical CURRENT DATE function.

Standards and compatibility

Example

The following statements return the current day according to the system clock.

SELECT TODAY( * );
SELECT CURRENT DATE;