Shulou(Shulou.com)05/31 Report--

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)

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.