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

MONTHNAME ( date_expression ) 

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’:

SELECT *
FROM orders
WHERE order_no =346 and MONTHNAME(order_date)=’JUNE’;
 
ORDER_NO ORDER_DATE  REFERENCE       CUST_NO
------- ---------   --------         -------
346     06/01/1991    87/rd          10002
 
1 record selected 

COMPATIBILITY

ODBC Compatible


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