DAY( )

The DAY( ) operator returns a positive integer, corresponding to the day portion of the value of its DATE or DATETIME operand.

The DAY( ) operator can extract an integer value for the day of the month from a DATETIME or DATE operand. This feature is helpful in some applications, because INTEGER values are easier than DATETIME or DATE values to manipulate with arithmetic operators.

References

MONTH( )

WEEKDAY( )

YEAR( )