Description:
Get the day from a date value.
Syntax:
day(dateExp)
Note:
The function gets the day from dateExp of date type.
Parameters:
dateExp |
Date expression whose result must be the date or the string of Chinese date and time format. |
Options:
@w |
Get the day of the week from the specified date. For Sunday, return 1; For Monday, return 2, and so on. By default, get the day of the month from the specified date. |
Return value:
Integer
Example:
day(datetime("19800227","yyyyMMdd")) |
27 |
day(datetime(12345)) |
1 |
day(datetime("2006-01-15 10:20:30")) |
15 |
day@w(datetime("19800227","yyyyMMdd")) |
4 |
day@w(datetime("2006-01-15 10:20:30")) |
1 |
Related functions: