Premium
Log in
MySQL Function Reference
DAY
Returns the ordinal number of the day in the month (from 1 to 31)
MySQL 8.1
DAY(datetime)datetime
DATE or DATETIME value
Examples
MySQL 8.1
SELECT DAY("2022-06-16");DAY(datetime)SELECT DAY("2022-06-16");