CURRENT DATE special value

Returns the current year, month, and day.

Data type

DATE

Remarks

The returned date is based on a reading of the system clock when the SQL statement is executed by the UltraLite runtime. If you use CURRENT DATE with any of the following, all values are based on separate clock readings:

  • CURRENT DATE multiple times within the same statement

  • CURRENT DATE with CURRENT TIME or CURRENT TIMESTAMP within a single statement

  • CURRENT DATE with the NOW function or GETDATE function within a single statement

See also