TODAY Function [Date and time]

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

Syntax

TODAY ( * )

Returns

DATE

Example

The following statement returns the current day according to the system clock.

SELECT TODAY( * ) FROM iq_dummy

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.

Parent topic: Alphabetical List of Functions