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