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