Transact-SQL Reference
DAY
Returns an integer representing the day datepart of the specified date.
Syntax
DAY ( date )
Arguments
date
Is an expression of type datetime or smalldatetime.
Return Type
int
Remarks
This function is equivalent to DATEPART(dd, date).
Examples
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