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

0 vote103 views3 answers
Find below average salary in sql
SQL
0 vote100 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote110 views3 answers
How to pass password to mysql command line
SQL
1 vote101 views1 answer
SQL date part only of datetime
SQL
0 vote100 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote101 views1 answer
Order by with where clause in mysql
SQL
2 votes102 views1 answer
While loop sql
SQL
0 vote108 views1 answer
Get initial in sql
SQL
0 vote93 views1 answer
Mysql select where text contains
SQL
0 vote117 views1 answer
Sql log file inof
SQL