mysql> select date_sub(last_day(now()),interval day(last_day(now()))-1 day) as 'first day of current month';+----------------------------+| first day of current month |+----------------------------+| 2017-10-01 |+----------------------------+1 row in set (0.00 sec)
以上就是如何在mysql中获取当月的第一天？的详细内容。