BigQuery Filter by Date

Question

I want to filter my data as per the DATE and TIME format '2016-01-09 16:31:04.000 UTC' using Legacy SQL in BigQuery. Kindly help me out with the correct syntax. I'm stuck.

Code

SELECT *
FROM
[table.column] AS Alias
WHERE
date >  '2017-03-31Z';

SELECT * FROM [table_name] where date BETWEEN '2016-01-09 16:31:04.000 UTC' AND — shakti nayan, May 29 '18 at 06:42
Simply update your question instead of putting the code in comments. — Dawid Rutkowski, May 29 '18 at 07:08

score 5 · Accepted Answer · answered May 29 '18 at 07:48

If the type of your column is timestamp then,

SELECT timestamp
FROM [bigquery-public-data:openaq.global_air_quality]
where timestamp > '2018-01-01 00:00:00'

If the type of the column is `string, then you can try,

SELECT timestamp
FROM [bigquery-public-data:openaq.global_air_quality]
where timestamp(timestamp) > timestamp('2018-01-01 00:00:00')

For more BigQuery Legacy SQL functions go here

BigQuery Filter by Date

1 Answers1