DAYOFMONTH(date)
Above function returns day of the month for the date in the range between 1 to 31, or 0 for the dates like '0000-00-00' or '2012-00-00', which have zero in day part.
SELECT DAYOFMONTH('2007-02-03'); o/p: 3
Above function returns day of the month for the date in the range between 1 to 31, or 0 for the dates like '0000-00-00' or '2012-00-00', which have zero in day part.
SELECT DAYOFMONTH('2007-02-03'); o/p: 3
No comments:
Post a Comment