MySQL example of getting today and yesterday's 0:00 timestamp

MySQL example of getting today and yesterday's 0:00 timestamp

As shown below:

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

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

To query today's records, you only need to have a timestamp whose creation time is greater than or equal to 0:00 today (only when there is no creation time greater than today). Yesterday's records are greater than or equal to 0:00 yesterday and less than 0:00 today.

The above example of how to get the 0:00 timestamp of today and yesterday in MySQL is all I have to share with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.

You may also be interested in:
  • MySQL statement to get all dates or months in a specified time period (without setting stored procedures or adding tables)
  • How to use MySQL DATEDIFF function to get the time interval between two dates
  • Mysql timeline data to obtain the first three data of the same day
  • Detailed explanation of MySQL to obtain statistical data for each day and each hour of a certain period of time
  • mysql gets yesterday's date, today's date, tomorrow's date, and the time of the previous hour and the next hour
  • mysql obtains statistical data within a specified time period
  • How to get time in mysql

<<:  How to use ss command instead of netstat in Linux operation and maintenance

>>:  Nginx's practical method for solving cross-domain problems

Recommend

Introduction to the graphic composition and typesetting capabilities of web design

Everything needs a foundation. To build a house, ...

A brief discussion on the optimization of MySQL paging for billions of data

Table of contents background analyze Data simulat...

CSS HACK for IE6/IE7/IE8/IE9/FF (summary)

Since I installed the official version of IE8.0, ...

HTML text escape tips

Today I saw a little trick for HTML text escaping ...

How to implement scheduled backup of MySQL in Linux

In actual projects, the database needs to be back...

MySQL/MariaDB Root Password Reset Tutorial

Preface Forgotten passwords are a problem we ofte...

Login interface implemented by html+css3

Achieve results First use HTML to build a basic f...

What are mysql dirty pages?

Table of contents Dirty pages (memory pages) Why ...

Centos7 installation of MySQL8 tutorial

MySQL 8 new features: My personal opinion on MySQ...

How to Develop a Progressive Web App (PWA)

Table of contents Overview Require URL of the app...

In-depth understanding of Worker threads in Node.js

Table of contents Overview The history of CPU-bou...

CSS pixels and solutions to different mobile screen adaptation issues

Pixel Resolution What we usually call monitor res...

Solution to the problem of mysql master-slave switch canal

After configuring VIP, the error message that app...

MySQL 8.0.15 version installation tutorial connect to Navicat.list

The pitfalls 1. Many tutorials on the Internet wr...

Vue uses Echarts to implement a three-dimensional bar chart

This article shares the specific code of Vue usin...