Shulou(Shulou.com)06/03 Report--

This article mainly gives you a brief talk about cloud computing learning mysql function usage demonstration, related technical terms you can check online or find some related books to supplement, here is not involved, we will go straight to the topic, I hope cloud computing learning mysql function usage demonstration This article can bring you some practical help.

When processing work orders today, one of the requirements is the delivery time of a certain commodity (that is, the time difference between the order time and the delivery time), and the TIMESTAMPDIFF function is contacted.

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)

The demonstration of the use of mysql function in cloud computing learning will be mentioned to you first. For other related issues, you can continue to pay attention to our industry information if you want to know. Our section content captures some industry news and expertise to share with you every day.

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.