How to make good use of TO_DAYS function for conditional operation of time field in mysql database
This article is to share with you about the mysql database time field condition operation how to make good use of the TO_DAYS function, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article. Let's take a look at it with the editor.
To_days function: returns the total number of days from 2000 (AD 1) to the current date. Note that several of the field names in the following examples are generally in YMD or Y-M-D format, not timestamped.
1. Use the to_days function to query today's data:
Select * from table name where to_days (time field name) = to_days (now ())
2. Use to_days function to query yesterday's data.
SELECT * FROM table name WHERE TO_DAYS (NOW ())-TO_DAYS (time field name)
