Get the App
SLTechnology News&Howtos  ›  Development  › 

How to get the date of the last day of the month in MySQL

Shulou Source: shulou.com Published: 2022-06-01 02:42:36 09月22日 Update

Editor to share with you how to get the date of the last day of the month in MySQL, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's learn about it!

LAST_DAY (date): gets the date of the last day of the month of the date

SELECT LAST_DAY (SYSDATE ()) SELECT LAST_DAY ('2015-02-02') SELECT LAST_DAY ('2015-02-02) SELECT LAST_DAY (' 2015-02-02) 2222)-> 2016-01-31-> 2015-02-28-> 2015-02-28 are all the contents of this article entitled "how to get the Last Day of the month in MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Tags: Date article content not much most more knowledge industry information information channel channel reference learning help Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi Microsoft Apple MySQL Shulou Information