3 kinds of functions for MYSQL time calculation

Method 1,

Addition

Adddate (' date_expression ', interval value type);

' date_expression ' + interval value type;

--------------------------------------------------------------------------------------------------------------- -------------------

Addtime (datetime_expression,time_expression);

' date_exression ' + interval + type;

Be careful:

If Addtime doesn't add time, it doesn't even have a date.

Method 2,

Subtraction

DateDiff (' datetime_expression_a, ' Datetime_expression_b ') returns the number of days obtained by A-B.

Method 3,

Time Zone transformations

Convert_tz (' datetime_expression ', ' Base_tz ', ' Target_tz ');

3 kinds of functions for MYSQL time calculation