4.9.2.91 TO_TIME function (extension)

Syntax

TO_TIME ( time_lit )

Description

The scalar function TO_TIME converts the given time literal to a time value.

Example

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

Notes

• The result is of type TIME.
• Supply the time literal in any valid format. See "Time Literals" for valid formats.