Shulou(Shulou.com)05/31 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.