Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## TO_DATE

> Converts the given date literal to a date value.

> #### Syntax

>     TO_DATE ( date_literal )

> Example

> This example illustrates the `TO_DATE` function, returning all columns from rows in the orders table where the `order_date` column is earlier or equal to the date ‘`12/31/2003`’:

>     SELECT *
>         FROM orders
>         WHERE order_date <= TO_DATE ('12/31/2003') ;

> #### Notes

> - The result is of type `DATE`.

> - Supply the date literal in any valid format.

> ##### Compatibility

> Progress extension

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