Home

Cookbook: BigQuery

Start here: BigQuery Console

SQL syntax

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.