MySQL中以秒为单位的两个时间戳之间的差异？

Ora esaminiamo i seguenti metodi per calcolare la differenza tra due timestamp (in secondi).

Metodo

Ecco la query che calcola la differenza tra due timestamp.

mysql> SELECT TIMESTAMPDIFF(SECOND, '2018-10-17 11:51:55', '2018-10-17 11:51:58');

Ecco l'output in secondi.

+---------------------------------------------------------------------+
| TIMESTAMPDIFF(SECOND, '2018-10-17 11:51:55', '2018-10-17 11:51:58') |
+---------------------------------------------------------------------+
|                                                                      3 |
+---------------------------------------------------------------------+
1 row in set (0.00 sec)

Metodo 2

Ecco la query che calcola la differenza tra due timestamp utilizzando UNIX timestamp.

mysql> SELECT UNIX_TIMESTAMP('2018-10-17 11:57:50') - UNIX_TIMESTAMP('2018-10-17 11:57:45') as DifferenceInSeconds;

Ecco l'output in secondi.

+---------------------+
| DifferenceInSeconds |
+---------------------+
|                      5 |
+---------------------+
1 row in set (0.00 sec)