days()

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