sql TIMESTAMP_DIFF计算时间差

SELECT
  TIMESTAMP("2010-07-07 10:20:00+00") AS later_timestamp,
  TIMESTAMP("2008-12-25 15:30:00+00") AS earlier_timestamp,
  TIMESTAMP_DIFF(TIMESTAMP "2010-07-07 10:20:00+00", TIMESTAMP "2008-12-25 15:30:00+00", HOUR) AS hours;

google bigquery 里面是前面的值减去后面的值

行	later_timestamp	earlier_timestamp	hours
1	2010-07-07 10:20:00 UTC	2008-12-25 15:30:00 UTC	13410

mysql 里面是后面的值减去前面的值

SELECT
"2010-07-07 10:20:00+00"  AS later_timestamp,
  "2008-12-25 15:30:00+00" AS earlier_timestamp,
  TIMESTAMPDIFF(day, "2010-07-07 10:20:00",  "2018-12-25 15:30:00") AS days;

later_timestamp	earlier_timestamp	days
2010-07-07 10:20:00+00	2008-12-25 15:30:00+00	3093