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

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.