Progress
SQL-92
Guide and Reference


YEAR Function

Returns the year as a short integer value in the range of 0-9999.

SYNTAX

YEAR ( date_expression ) 

EXAMPLE

The example illustrates the YEAR function. The query returns all columns in rows in the orders table where the year in the order_date column is equal to ’1992’:

SELECT *
    FROM orders
    WHERE YEAR (order_date) = 1992; 

NOTES

COMPATIBILITY

ODBC Compatible


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