Description:
Get the month from a specified date/datetime value.
Syntax:
month(dateExp)
Note:
The function gets the month from the date dateExp.
Parameter:
|
dateExp |
An expression whose result is a date or a datetime value of standard format; it can be an integer, which we can regard as the value of computing days@o(). |
Option:
|
@y |
Return a 6-digit number if there is a year part in the parameter. |
Return value:
Integer
Example:
|
month(datetime("19800227","yyyyMMdd")) |
2 |
|
month("1972-11-08 10:20:30") |
11 |
|
month(datetime("2006-01-15 13:20:30")) |
1 |
|
month@y("1972-11-08 10:20:30") |
197211 |
|
month(20742) |
1 |
Related function: