'day() vs dayofmonth() in mysql

Consider

select day("2016-05-22")

and

select dayofmonth("2016-05-22")

both gives the same output.

day("2016-05-22")
22

and

dayofmonth("2016-05-22")
22

Is there any diffrence between these two methods?



Solution 1:[1]

According to the MySQL reference manual DAY() is a synonym for DAYOFMONTH()

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Szeki