CURRENT_DATE

1
SELECT
2
  CURRENT_DATE() as today,
3
  CURRENT_DATE('Asia/Jakarta') as today_jakarta,
4
  CURRENT_DATE('America/New_York') as today_ny;

1
SELECT *
2
FROM `project.dataset.orders`
3
WHERE order_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY);

1
SELECT
2
  name,
3
  birth_date,
4
  DATE_DIFF(CURRENT_DATE(), birth_date, YEAR) as age
5
FROM `project.dataset.users`;