Returns the current date.

Syntax

TODAY( * )

Returns

DATE

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;