Progress
SQL-92
Guide and 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/1999’:

SELECT *
    FROM orders
    WHERE order_date <= TO_DATE (’12/31/1999’) ; 

NOTES

COMPATIBILITY

Progress Extension


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