4.9.2.51 MONTHNAME function (ODBC compatible)

Syntax

MONTHNAME ( date_expression )

Description

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 name of a column, the result of another scalar function, or a date or timestamp literal.

Example

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