DAY() function returns day number of the month from 1-31

Example

SELECT DAY( '1999-02-03' )

Returns

3