DAY Function

Returns the day-of-month part of a date/time string.

Syntax

DAY(date)

Parameters

Return Value

An integer representing the specified day of the month.

Examples

PRINT DAY('2016-03-07');  -- "7"
PRINT DAY('2016-07-23 22:06:53.742 -04:00'); -- "23"