Bigquery declare

DECLARE fromdate TIMESTAMP DEFAULT '2014-01-01 00:00:00';  -- dates for after 2013
DECLARE todate TIMESTAMP DEFAULT '2015-01-01 00:00:00';

DECLARE bfromdate TIMESTAMP DEFAULT '2005-01-01 00:00:00'; -- dates for before 2013
DECLARE btodate TIMESTAMP DEFAULT '2005-01-01 00:00:00';

DECLARE achfromdate TIMESTAMP DEFAULT '2013-01-01 00:00:00'; -- dates for ACH without submit time in 2013
DECLARE achtodate TIMESTAMP DEFAULT '2013-01-01 00:00:00';

DECLARE currency STRING DEFAULT "USD";

Source: stackoverflow.com

Similar codes

8 votes127 views3 answers
Connect python to mysql
SQL
4 votes127 views2 answers
Oracle set date format
SQL
2 votes138 views1 answer
Sql skip the first row
SQL
1 vote133 views1 answer
Change table to innodb mysql
SQL
7 votes124 views1 answer
Postgres base size
SQL
0 vote111 views1 answer
How to get employee having maximum experience in mysql
SQL
0 vote127 views1 answer
Change date in pivot table to month in sql server
SQL
1 vote144 views1 answer
Sql group by sum with condition
SQL
9 votes143 views6 answers
Check constraint in sql
SQL
1 vote135 views1 answer
Import sql file mysql commadn line
SQL