How to set time query conditions in mysql

Method: 1. Use "DATE_ADD(date,INTERVAL expr type)" to add the specified time interval to the date; 2. Use "DATE_SUB(date,INTERVAL expr type)" to subtract the specified time interval from the date; 3. , use the "TO_DAYS" function, etc.

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How to set time query conditions in mysql

DATE_ADD() function

DATE_ADD() function adds the specified time interval to the date.

DATE_ADD(date,INTERVAL expr type)

date parameter is a legal date expression. The expr parameter is the time interval you wish to add.

type parameters can be the following values: SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR, etc.

DATE_SUB function

DATE_SUB Function subtracts a specified time interval from a date.

DATE_SUB(date,INTERVAL  expr type)

The date parameter is the date expression of Hefei. The expr parameter is the time interval you wish to add.

The type parameter can be the following values: SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR, etc.

DATE_FORMAT() function

DATE_FORMAT() function is used to display date/time data in different formats

DATE_FORMAT(date,format)

The date parameter is the date. format specifies the output format of date/time, which can be the following values: %h hour 01-12, %m month, %s second, %y year 2 digits

TO_DAYS() function

Calculate the number of days from year 0 to a given time.

FROM_UNIXTIME() function

Convert timestamp to date. Note that the timestamp in mysql is 10 digits.

UNIX_TIMESTAMP() function

Date to timestamp

SELECT NOW() FROM DUAL
SELECT to_days(now()) FROM DUAL
SELECT date_format(now(),'%Y-%m-%d') FROM DUAL
SELECT DATE_SUB(NOW(),INTERVAL 3 DAY) FROM dual
SELECT DATE_ADD(NOW(),INTERVAL 3 DAY) FROM dual

Recommended learning: mysql video tutorial

The above is the detailed content of How to set time query conditions in mysql. For more information, please follow other related articles on the PHP Chinese website!