Loading lesson path
Concept visual
Start at both ends
Return the day of the month for a date:
SELECT DAY('2017/08/25') AS DayOfMonth;The DAY() function returns the day of the month (from 1 to 31) for a specified date.
date )
Required. The date to return the day of the month fromint
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Return the day of the month for a date: SELECT DAY('2017/08/13 09:08') AS DayOfMonth;
❮ SQL Server Functions