Home

Cookbook: BigQuery

Start here: BigQuery Console

SQL syntax

See: CINF 201 notes
See: BigQuery docs

Extracting hour, minute, etc. from dates

extract(HOUR FROM myfield)
extract(MINUTE FROM myfield)
extract(DAYOFWEEK FROM myfield)

CINF 401 material by Joshua Eckroth is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License. Source code for this website available at GitHub.