CODE EXAMPLE FOR SQL

bigquery get current date

SELECT CURRENT_DATE() AS the_date;