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

As follows:

Yesterday: UNIX_TIMESTAMP (CAST (SYSDATE () AS DATE)-INTERVAL 1 DAY)

Today: UNIX_TIMESTAMP (CAST (SYSDATE () AS DATE))

To query records within today, as long as the creation time is greater than or equal to today's 0: 00 timestamp (only if there is no creation time greater than today's), the record in yesterday is greater than or equal to yesterday's 0: 00 less than today's 0: 00.

The above example of mysql getting the 0: 00 timestamp today and yesterday is all the content that the editor has shared with you. I hope I can give you a reference and I hope you can support 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.