Use this function to find the name of the month in a given date and return that name.
|
Parameter |
Description |
|
Month |
Enter a valid month value. For example, enter one (1) for January or 12 for December. The default is the current month. |
|
Locale |
(Optional) Enter the locale code. If you omit this parameter, the system checks the Locale INI option. If the Locale INI option offers no value, the system defaults to USD (United States/English). |
This function is most often used with the Month function. The Month function extracts the month number from a given date.
Here are some examples:
(Assume the current date is 07/01/09.)
|
Function |
Result |
Explanation |
|
Return(MonthName ( )) |
July |
Defaults to the current month. |
|
Return(MonthName (11)) |
November |
Returns November, which corresponds to the given parameter (11). |
|
Return(MonthName (Month ("09/138", "I") )) |
May |
First the Month function determines that the month number for the given date is 5. (09/138 is equivalent to May 18, 2009) Then MonthName returns the corresponding month name of May. |
© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices