difference in minutes between 2 bigquery timestamp fields

google-bigquery
user3569267 picture user3569267 · May 16, 2014 · Viewed 29.8k times · Source

How can I get the difference in minutes between 2 timestamp fields in google bigquery? The only function I know is Datediff which gives the difference in day

Thanks

Answer

Paul Bendevis picture Paul Bendevis · Dec 2, 2016

Pentium10's answer works for Legacy SQL. If you're using Standard SQL you can use TIMESTAMP_DIFF and it will do the math for you:

TIMESTAMP_DIFF(timestamp_1, timestamp_2, MINUTE)

https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#timestamp-functions

Related questions

Setting GOOGLE_APPLICATION_CREDENTIALS for BigQuery Python CLI

I'm trying to connect to Google BigQuery through the BigQuery API, using Python. I'm following this page here: https://cloud.google.com/bigquery/bigquery-api-quickstart My code is as follows: import os import argparse from apiclient.discovery import build from apiclient.…

Read More
Google BigQuery Delete Rows?

Anyone know of any plans to add support for delete parts of data from a table in Google Bigquery? The issue we have right now is we are using it for analytics of data points we collect over time. We …

Read More
Can we cast the type in BigQuery?

Following my query : SELECT SQRT((D_o_latitude - T_s_lat)^2+(D_o_longitude - T_s_long)^2)/0.00001 FROM [datasetName.tableName] I am getting the error as Error: Argument type mismatch in function SUBTRACT:'D_o_latitude' is type …

Read More