Monthname function

Returns a string indicating the specified month.

Syntax

MonthName ( month [, abbreviate ] )

The MonthName function syntax has these arguments:

Argument	Description
month	Required. The numeric designation of the month. For example, January is 1, February is 2, and so on.
abbreviate	Optional. Boolean value that indicates if the month name is to be abbreviated. If omitted, the default is False, which means that the month name is not abbreviated.

Query examples

Expression	Results
SELECT Monthname("10") AS Expr1 FROM ProductSales;	Returns the "Full" name of the month for the number representing the 'month'. Result: "October".
SELECT Monthname("10",True) AS MonthTest FROM ProductSales;	Returns the "abbreviated" name of the month for the number representing the 'month' and displays in the column "MonthTest".Result: "Oct" returns the "Full" name of 'month' of the values in the field "DateofSale" from the table "ProductSales" and displays in the column "MonthTest".

Choose the right date function