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)
Start here: BigQuery Console
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.