DAY (TSQL Function)

Returns the day of the specified date.

Syntax

DAY ( date )

Arguments

date
is an expression of type date or datetime.

Return Types

Returns int.

Examples

PRINT DAY('2016-10-04');

The result is:

4