CURRENT TIME

The CURRENT TIME special register specifies a time that is based on a reading of the time-of-day clock when the SQL statement is executed at the current server. If this special register is used more than once within a single SQL statement, or used with CURRENT DATE, CURRENT TIMESTAMP, or the CURDATE, CURTIME, or NOW scalar functions within a single statement; all values are based on a single clock reading.28

Example

Using the CL_SCHED table, select all the classes (CLASS_CODE) that start (STARTING) later today. Today's classes have a value of 3 in the DAY column.

   SELECT CLASS_CODE FROM CL_SCHED
     WHERE STARTING > CURRENT TIME  AND DAY = 3

28.
LOCALTIME and LOCALTIME(0) can be specified as a synonyms for CURRENT_TIME.