Google BigQuery SQL Dates and Times Cheat Sheet

A cheat sheet for common BigQuery date and time expressions

Photo by Sonja Langford on Unsplash

I have just started working on a time series forecasting project this morning. The first step in this project, as with most data science tasks, was to gather the data first. This meant a relatively simple SQL query in Google BigQuery. Once again I found myself googling how to extract…