Progress
SQL-92
Guide and Reference


TO_TIME Function

Converts the given time literal to a time value.

SYNTAX

TO_TIME ( time_literal ) 

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/1991’) 
    AND order_time < TO_TIME (’12:00:00’) ; 

NOTES

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095