Shulou(Shulou.com)06/01 Report--

The following mainly brings you mysql to get the specified date function application, I hope these contents can bring you practical use, this is also the main purpose of this article that I edit mysql to get the specified date function application. All right, don't talk too much nonsense, let's just read the following.

Get the number of days of the specified date in the current month select dayofmonth (last_day (concat ('2018-01-21')) monthCount gets the next day of the specified date, the previous day uses a positive number select date_sub (' 2018-03-01 minute interval-1 day) nextDay to get the next day of the specified current date, and the previous day uses a positive number

Select date_sub (curdate (), interval-1 day) nextDay

For the above mysql to get the specified date function application, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.