MySql calculates the time difference between two dates.

Source: Internet
Author: User

MySql calculates the time difference between two dates.

MySql calculates the difference between two date and time functions:

First, the TIMESTAMPDIFF function requires three parameters. The first parameter is a comparison type, FRAC_SECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, or YEAR can be compared. The SECOND and third parameters are the time to be compared, the comparison is the last time minus the previous time. The usage is as follows:

SELECT TIMESTAMPDIFF(DAY,'2012-10-01','2013-01-13');
The returned result is 104. The difference in the number of days between the two time periods is compared;

SELECT TIMESTAMPDIFF(MONTH,'2012-10-01','2013-01-13');

Here we compare the two time months, and the returned result is 3;

The second method is the DATEDIFF function. Two date functions are passed in to compare the DAY days. The first parameter minus the DAY value of the second parameter. The specific usage is as follows:

SELECT DATEDIFF('2013-01-13','2012-10-01');
The returned result is 104.

Other date functions,

The now () function returns the year, month, day, hour, minute, and second of the current time, for example, 16:25:46.

The CURDATE () function returns the year, month, and day information, for example ,.

The CURTIME () function returns the hour, minute, and second information of the current time, for example, 16: 25: 46.

In addition, if you want to format a DATE that contains year, month, day, hour, minute, second, and DATE, you can use the DATE (time) function, such

DATE (now () returns2008-12-29


Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.