Day

Retrieve the day of the month from the specified date.

SELECT Day(#05/17/2017#);

Definition and Usage

The DAY() function returns the day of the month for a given date as an integer between 1 and 31.

Day(date)

Parameter	Description
date	Mandatory. A numeric or string expression that represents a valid date.

WORKS IN

From Access 2000

Retrieve the day of the month for the current date.

SELECT Day(Date());

Retrieve the day of the month from the “BirthDay” column in the “Employees” table.

SELECT Day(BirthDate) FROM Employees;