ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

TODAY function [Date and time]

Function 

Returns the current date. This is the historical syntax for CURRENT DATE.

Syntax 

TODAY ( * )

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

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

SELECT TODAY( * )
SELECT CURRENT DATE