时间戳中的mysql时间戳差异

Question

我想了解时间戳之间的区别，以时间戳格式，仅使用 MySQL 而不是使用编程语言。也不以秒、小时、日期、月或年为单位。举个例子。

timestamp1->2012-05-21 15:31:11
timestamp2->2012-05-21 15:32:11

我想得到时间戳格式的结果。

所以结果应该是

result->0000-00-00 00:01:00

Answer 1

使用 MySQL 的 TIMEDIFF()功能:

TIMEDIFF() returns expr1 – expr2 expressed as a time value. expr1 and expr2 are time or date-and-time expressions, but both must be of the same type.

The result returned by TIMEDIFF() is limited to the range allowed for TIME values. Alternatively, you can use either of the functions TIMESTAMPDIFF() and UNIX_TIMESTAMP(), both of which return integers.

mysql> SELECT TIMEDIFF('2000:01:01 00:00:00',    ->                 '2000:01:01 00:00:00.000001');        -> '-00:00:00.000001'mysql> SELECT TIMEDIFF('2008-12-31 23:59:59.000001',    ->                 '2008-12-30 01:01:01.000002');        -> '46:58:57.999999'