DAY (Date) DAY (Date) Date Temporal Temporal The date. Returns Number Number The day of the given date (1 through 31). Details Returns the day of the month of a given date, as a number from 1 through 31. See also MONTH and YEAR for extracting other components of a date, and DATE for constructing a date from its components. Example DAY ( DATE (2013, 1, 5)) DAY ( DATE (2013; 1; 5)) Returns 5, the day of the given date, January 5, 2013.