Description:
Get the number of days of the year, quarter or month to which the specified date belongs.
Syntax:
days(dateExp)
Note:
The function gets the number of days of the year, quarter or month to which the specified date dateExp belongs.
Parameters:
|
dateExp |
A date or a date string of standard format |
Options:
|
@q |
Get the number of days of the quarter to which the specified date belongs |
|
@y |
Get the number of days of the year to which the specified date belongs By default get the number of days of the month to which the specified date belongs |
Return value:
Integer
Example:
|
days(datetime("19800227","yyyyMMdd")) |
29 |
|
days(datetime("2006-01-15 10:20:30")) |
31 |
|
days@y(datetime("19800227","yyyyMMdd")) |
366 |
|
days@q(datetime("2006-01-15 10:20:30")) |
90 |