Returns an integer representing the day datepart of the specified date.
DAY(date)
int
This function is equivalent to DATEPART(dd, date).
This example returns the number of the day from the date 03/12/1998.
SELECT DAY('03/12/1998') AS 'Day Number'
GO
Here is the result set:
Day Number
------------
12
In this example, the date is specified as a number. Notice that Microsoft® SQL Server™ interprets 0 as January 1, 1900.
SELECT MONTH(0), DAY(0), YEAR(0)
Here is the result set.
----- ------ ------
1 1 1900
datetime and smalldatetime | Date and Time Functions |
Expressions |