Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL language elements » Special values in UltraLite

CURRENT UTC TIMESTAMP special value - UltraLite

Returns a TIMESTAMP WITH TIME ZONE value that reflects the current UTC time containing the 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.

  • 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