Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## TO_TIME

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

> #### Notes

> - The result is of type `TIME`.

> - Supply the time literal in any valid format.

> ##### Compatibility

> Progress extension

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