Return the date’s day of the month.
| SELECT DAY(‘2017/08/25’) AS DayOfMonth; |
The DAY() function returns the day of the month (ranging from 1 to 31) for a given date.
| DAY(date) |
|
Parameter |
Description |
|
date |
Required. The date from which to extract the day of the month. |
|
Return type: |
int |
|
Works in: |
SQL Server (from 2008 onward), Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse |
Retrieve the day of the month from a given date.
| SELECT DAY(‘2017/08/13 09:08’) AS DayOfMonth; |