Progress
SQL-92
Guide and Reference
YEAR Function
Returns the year as a short integer value in the range of 0-9999.
SYNTAX
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’:
NOTES
- The argument to the function must be of type DATE.
- If
date_expression
is supplied as a date literal, it can be any of the validdate_literal
formats where the day specification (DD
) precedes the month specification (MM
). See the syntax for adate_literal
in the “Date Literals” section.- The result is of type SHORT.
- If the argument expression evaluates to NULL, the result is NULL.
COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |