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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL elements reference » Special values in UltraLite


CURRENT TIME special value

The current hour, minute, second, and fraction of a second.

Data type



The fraction of a second is stored to 6 decimal places. The accuracy of the current time is limited by the accuracy of the system clock.

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 TIME with any of the following, all values are based on separate clock readings:

  • CURRENT TIME multiple times within the same statement
  • CURRENT TIME with CURRENT DATE or CURRENT TIMESTAMP within a single statement
  • CURRENT TIME with the NOW function or GETDATE function within a single statement
See also