This function returns an integer representing the day when the fraction of the expression is interpreted as a date according to the standard number interpretation.
The function returns the day of the month for a particular date. It is commonly used to derive a day field as part of a calendar dimension.
Syntax:
day(expression)
Return data type: integer
| Example | Result |
|---|---|
|
day( '1971-10-12' ) |
returns 12 |
| day( '35648' ) | returns 6, because 35648 = 1997-08-06 |