date - prayagupa/rdb GitHub Wiki

SELECT * FROM `ads_timeline` 
WHERE date(event_date)>= DATE_SUB(current_date(), INTERVAL 14 DAY)
AND user_id='1234';

• Format timestamp
• https://cloud.google.com/bigquery/docs/reference/standard-sql/format-elements

SELECT 
FORMAT_TIMESTAMP("%Y-%m-%d %H:%M:00", TIMESTAMP "2023-12-13 15:30:12+00") AS formatted;
-- 2023-12-13 15:30:00