如何使用bigquery在新列中减去两列以获得它们之间的时间差

Question

我只需要制作时差的新列。started_at ended_at2020-01-21 20:06:59 2020-01-21 20:14:302020-01-30 14:22:39 2020-01-30 14:26:222020-01-09 19:29:26 2020-01-09 19:32:172020-01-06 16:17:072020-01-30 8:42:482020-01-10 12:33:052020-01-10 13:07:35

Answer 1

SELECT TIMESTAMP_DIFF(ended_at, started_at, SECOND) AS duration_seconds

https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions timestamp_diff