SQL Reference Guide

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 of TIME literals.