© 2025 by The Clinic. Powered and secured by Wix
Syntax:DAYOFMONTH(date)Returns the day of the month for date, in the range 1 to 31, or 0 fordates such as '0000-00-00' or '2008-00-00' that have a zero day part.
mysql> SELECT DAYOFMONTH('2007-02-03'); -> 3