Day Function in SQL Server

DAY()

This is used to get the day from any date time object.

Example:
SELECT DAY(getdate()) AS 'DAY'
 

Output :
DAY
17

Back