TIME

Returns a time from a value. The argument must be a timestamp, a time, or a valid string representation of a time.

Example:

Select all notes from the IN_TRAY sample table that were received at least one hour later in the day (any day) than the current time.

  SELECT * FROM IN_TRAY
    WHERE TIME(RECEIVED) >= CURRENT TIME + 1 HOUR