day

Returns the day of the month (1-31) from "date_expression". "Date_expression" can be a date value or a string representation of a date.

day ( date_expression )

day ( '1998-01-08' )