Progress
SQL-92
Guide and Reference


MONTH Function

Returns the month in the year specified by the argument as a short integer value in the range of 1-12.

SYNTAX

MONTH ( date_expression ) 

EXAMPLE

This example illustrates the MONTH function:

SELECT * FROM orders WHERE MONTH (order_date) = 6 ; 

NOTES

COMPATIBILITY

ODBC Compatible


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