TIME scalar function
The TIME function returns a time from a value.
The schema is SYSIBM.
- An expression that returns a value of one of the following built-in data types: DATE, TIME, TIMESTAMP, or a valid character string representation of a date, time, or timestamp that is not a CLOB. In a Unicode database, if an expression returns a value of a graphic string data type, the value is first converted to a character string before the function is executed.
The result of the function is a TIME. If the argument can be null, the result can be null; if the argument is null, the result is the null value.
The other rules depend on the data type of the argument:
- If the argument is a DATE or string representation
of a date:
- The result is midnight.
- If the argument is a TIME:
- The result is that time.
- If the argument is a TIMESTAMP:
- The result is the time part of the timestamp.
- If the argument is a string representation
of time or timestamp:
- The result is the time represented by the string.
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