This function returns a dual value with a month name as defined in the environment variable MonthNames and an integer between 1-12. The month is calculated from the date interpretation of the expression, according to the standard number interpretation.
Syntax:
month(expression)
Return data type: dual
Examples and results:
| Example | Result |
|---|---|
|
month( '2012-10-12' ) |
returns Oct |
| month( '35648' ) | returns Aug, because 35648 = 1997-08-06 |
