Progress
SQL-92
Guide and Reference
MONTHNAME Function
Returns a character string containing the name of the month (for example, January through December) for the month portion of date_expression. Argument date_expression can be the name of a column, the result of another scalar function, or a date or timestamp literal.
SYNTAX
EXAMPLE
This example illustrates the MONTHNAME function. The query returns all rows where the name of the month in the order_date column is equal to ’June’:
COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |