MySQL calculates the number of days, months, and years between two dates
|
The MySQL built-in date function TIMESTAMPDIFF calculates the number of seconds, minutes, hours, days, weeks, quarters, months, years between two dates, and increases or decreases the current date by one day, a week, etc. SELECT TIMESTAMPDIFF(type, start time, end time) Difference in seconds: SELECT TIMESTAMPDIFF(SECOND,'1993-03-23 00:00:00',DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')) Difference in minutes: SELECT TIMESTAMPDIFF(MINUTE,'1993-03-23 00:00:00',DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')) Difference in hours: SELECT TIMESTAMPDIFF(HOUR,'1993-03-23 00:00:00 00:00:00',DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')) Difference in days: SELECT TIMESTAMPDIFF(DAY,'1993-03-23 00:00:00',DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')) Weeks difference: SELECT TIMESTAMPDIFF(WEEK,'1993-03-23 00:00:00',DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')) Number of quarters difference: SELECT TIMESTAMPDIFF(QUARTER,'1993-03-23 00:00:00',DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')) Difference in months: SELECT TIMESTAMPDIFF(MONTH,'1993-03-23 00:00:00',DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')) Difference in years: SELECT TIMESTAMPDIFF(YEAR,'1993-03-23 00:00:00',DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')) Get the current date: SELECT NOW() SELECT CURDATE() Add one day to the current date: SELECT DATE_SUB(CURDATE(),INTERVAL -1 DAY) Subtract one day from the current date: SELECT DATE_SUB(CURDATE(),INTERVAL 1 DAY) Add one week to the current date: SELECT DATE_SUB(CURDATE(),INTERVAL -1 WEEK) SELECT DATE_SUB(NOW(),INTERVAL -1 MONTH) Add one month to the current date: SELECT DATE_SUB(CURDATE(),INTERVAL -1 MONTH) FRAC_SECOND milliseconds SECOND seconds MINUTE minutes HOUR hours DAY days WEEK weeks MONTH months QUARTER quarters YEAR years Summarize The above is the introduction of MySQL to calculate the number of days, months, and years between two dates. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website! You may also be interested in:
|
<<: JS implements WeChat's "shit bombing" function
>>: How to install JDK and set environment variables in Linux (this article is enough)
Recommend
Detailed steps to store emoji expressions in MySQL
Caused by: java.sql.SQLException: Incorrect strin...
What are the differences between xHTML and HTML tags?
All tags must be lowercase In XHTML, all tags must...
Three.js sample code for implementing dewdrop animation effect
Preface Hello everyone, this is the CSS wizard - ...
HTML web page creation tutorial Use iframe tags carefully
Using iframes can easily call pages from other we...
Instructions for deploying projects to remote machines using the Publish Over SSH plugin in Jenkins
Publish Over SSH Plugin Usage Before using Publis...
Vue implements the sample code of associating the side navigation bar with the Tab page
Table of contents Technology Stack Effect analyze...
Automatic backup of MySQL database using shell script
Automatic backup of MySQL database using shell sc...
Linux solves the problem that Deepin cannot start Google Chrome browser as root user
To solve the problem that Deepin cannot start Goo...
A simple example of MySQL joint table query
MySql uses joined table queries, which may be dif...
Vue.js implements image switching function
This article shares the specific code of Vue.js t...
MySQL query data by hour, fill in 0 if there is no data
Demand background A statistical interface, the fr...
VMware kali virtual machine environment configuration method
1|0 Compile the kernel (1) Run the uname -r comma...
MySQL EXPLAIN statement usage examples
Table of contents 1. Usage 2. Output results 1.id...
Use label tag to select the radio button by clicking the text
The <label> tag defines a label (tag) for an...
Some major setting modification records when upgrading from kubernetes1.5.2 to kubernetes1.10
This article records some major setting changes w...