Detailed explanation of MySQL date addition and subtraction functions
|
1. addtime() Add the specified number of seconds to the date select addtime(now(),1); -- add 1 second 2. adddate() There are two ways to use it. If you fill in a number directly in the second parameter, it will add the specified number of days to the date. If you fill in interval, it will add the specified interval time to the date. select adddate(now(),1); -- add 1 dayselect adddate(now(), interval 1 day); -- add 1 dayselect adddate(now(), interval 1 hour); -- add 1 hourselect adddate(now(), interval 1 minute); -- add 1 minuteselect adddate(now(), interval 1 second); -- add 1 secondselect adddate(now(), interval 1 microsecond); -- add 1 millisecondselect adddate(now(), interval 1 week); -- add 1 weekselect adddate(now(), interval 1 month); -- add 1 monthselect adddate(now(), interval 1 quarter); -- add 1 quarterselect adddate(now(), interval 1 year); -- add 1 year 3. date_add() Add a time interval to the date. This can only use the interval time as a parameter. The usage is the same as adddate() select date_add(now(), interval 1 day); -- add 1 dayselect date_add(now(), interval 1 hour); -- add 1 hourselect date_add(now(), interval 1 minute); -- add 1 minuteselect date_add(now(), interval 1 second); -- add 1 secondselect date_add(now(), interval 1 microsecond); -- add 1 millisecondselect date_add(now(), interval 1 week); -- add 1 weekselect date_add(now(), interval 1 month); -- add 1 monthselect date_add(now(), interval 1 quarter); -- add 1 quarterselect date_add(now(), interval 1 year); -- add 1 year 4. subtime() Subtract the specified number of seconds from the date select subtime(now(), 1); -- minus 1 second 5. subdate() The usage is the same as adddate() function. There are two usages. If you fill in a number directly in the second parameter, it will subtract the specified number of days from the date. If you fill in interval, it will subtract the specified interval time from the date. select subdate(now(),1); -- subtract 1 dayselect subdate(now(), interval 1 day); -- subtract 1 dayselect subdate(now(), interval 1 hour); -- subtract 1 hourselect subdate(now(), interval 1 minute); -- subtract 1 minuteselect subdate(now(), interval 1 second); -- subtract 1 secondselect subdate(now(), interval 1 microsecond); -- subtract 1 millisecondselect subdate(now(), interval 1 week); -- subtract 1 weekselect subdate(now(), interval 1 month); -- subtract 1 monthselect subdate(now(), interval 1 quarter); -- subtract 1 quarterselect subdate(now(), interval 1 year); -- subtract 1 year 6. date_sub() Same as date_add() function, subtract a time interval from the date. This function can only use interval time as a parameter. select date_sub(now(), interval 1 day); -- subtract 1 dayselect date_sub(now(), interval 1 hour); -- subtract 1 hourselect date_sub(now(), interval 1 minute); -- subtract 1 minuteselect date_sub(now(), interval 1 second); -- subtract 1 secondselect date_sub(now(), interval 1 microsecond); -- subtract 1 millisecondselect date_sub(now(), interval 1 week); -- subtract 1 weekselect date_sub(now(), interval 1 month); -- subtract 1 monthselect date_sub(now(), interval 1 quarter); -- subtract 1 quarterselect date_sub(now(), interval 1 year); -- subtract 1 year This is the end of this article about the detailed explanation of MySQL date addition and subtraction functions. For more relevant MySQL date addition and subtraction function summary content, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future! You may also be interested in:
|
<<: Vue simulates the shopping cart settlement function
>>: Linux performance monitoring tool nmon installation and usage tutorial analysis
Recommend
MySQL learning to create and operate databases and table DDL for beginners
Table of contents 1. Operate the database 1.1 Cre...
Introduction to the use of html area image hotspots with a list of related properties
The <area> tag is mainly used in image maps...
Explain TypeScript enumeration types in detail
Table of contents 1. Digital Enumeration 2. Strin...
Detailed tutorial on deploying Jenkins based on docker
0. When I made this document, it was around Decem...
IDEA reports an error when connecting to MySQL! Server returns invalid timezone. Go to tab and set serverTimezone property
The road ahead is always so difficult and full of...
JavaScript to implement retractable secondary menu
The specific code for implementing the retractabl...
Mysql sorting to get ranking example code
The code looks like this: SELECT @i:=@i+1 rowNum,...
JS Easy to understand Function and Constructor
Table of contents 1. Overview 1.1 Creating a func...
How to install mysql5.7.24 binary version on Centos 7 and how to solve it
MySQL binary installation method Download mysql h...
JavaScript to achieve a simple message board case
Use Javascript to implement a message board examp...
5 Reasons Why Responsive Web Design Isn’t Worth It
This article is from Tom Ewer's Managewp blog,...
Detailed explanation of Kubernetes pod orchestration and lifecycle
Table of contents K8S Master Basic Architecture P...
Detailed explanation of the time representation example of the Linux time subsystem
Preface In the Linux kernel, in order to be compa...
How to configure port forwarding for docker on CentOS 7 to be compatible with firewall
On CentOS 7, when we map the host port to the con...
Why Google and Facebook don't use Docker
The reason for writing this article is that I wan...