Converts the given time literal to a time value.

Syntax

TO_TIME ( time_literal )

Notes

  • The result is of type TIME.
  • Supply the time literal in any valid format.

Example

The following example shows how to use the TO_DATE and the TO_TIME functions:

SELECT * FROM orders
    WHERE order_date < TO_DATE ('05/15/2003') 
    AND order_time < TO_TIME ('12:00:00') ;

Compatibility

Progress extension