How to use TIMESTAMPDIFF function in mysql
Xiaobian to share with you how to use the TIMESTAMPDIFF function in mysql, I hope you have gained something after reading this article, let's discuss it together!
TIMESTAMPDIFF
TIMERSTAMPDIFF Syntax:
TIMERSTAMPDIFF(interval,datetime_expr1,datetime_expr2)
Description:
This function returns the integer difference between datetime_expr1 and datetime_expr2, where the unit is determined by the interval parameter. The common parameters of interval are:
FRAC_SECOND interval is milliseconds
SECOND Time interval is seconds
MINUTE Time interval is minutes
HOUR Time interval is hours
DAY Time interval is days
WEEK time interval is weeks
MOUTH time interval is month
QUARTER Time interval is quarterly
YEAR Time interval is year
Examples:
MariaDB [(none)]> select timestampdiff(hour,'2018-06-05 09:00:00','2018-06-15 09:00:00');
+-----------------------------------------------------------------+
| timestampdiff(hour,'2018-06-05 09:00:00','2018-06-15 09:00:00') |
+-----------------------------------------------------------------+
| 240 |
+-----------------------------------------------------------------+
1 row in set (0.00 sec)
Example 2:
MariaDB [(none)]> select timestampdiff(day,'2018-06-05 09:00:00','2018-06-15 09:00:00');
+----------------------------------------------------------------+
| timestampdiff(day,'2018-06-05 09:00:00','2018-06-15 09:00:00') |
+----------------------------------------------------------------+
| 10 |
+----------------------------------------------------------------+
1 row in set (0.00 sec)
After reading this article, I believe you have a certain understanding of "how to use TIMESTAMPDIFF function in mysql". If you want to know more about it, welcome to pay attention to the industry information channel. Thank you for reading!
