MS Access MonthName() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MS Access MonthName() Function
❮ MS Access Functions
Example
Return the name of the month based on a number:
SELECT MonthName(3);
Definition and Usage
The MonthName() function returns the name of the month based on a number.
Syntax
MonthName(number, abbreviate)
Parameter Values
Parameter | Description |
---|---|
number | Required. A value from 1 to 12, that represent the month |
abbreviate | Optional. A Boolean value. True = the month name should be abbreviated. False = the month name should not be abbreviated. False is default |
Technical Details
Works in: | From Access 2000 |
---|
More Examples
Example
Return the abbreviated name of the month based on a number:
SELECT WeekdayName(3, true);
❮ MS Access Functions