DAY (T-SQL)

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

  

See Also
datetime and smalldatetime Date and Time Functions
Expressions  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.