❓
Knowledge Base
🏒
BigQuery
Use
*_TRUNC
instead of format, e.g.
TIMESTAMP_TRUNC(timestamp, DAY) AS timestamp_day,