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

1 vote175 views1 answer
Postgres set column based on another column
SQL
0 vote161 views1 answer
Mysql update privileges
SQL
1 vote184 views1 answer
Increase existing date in sql
SQL
27 votes183 views3 answers
Mysql show tables in database
SQL
0 vote156 views1 answer
Sql random decimal
SQL
4 votes167 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
14 votes182 views2 answers
Oracle add attribute to table
SQL
14 votes184 views4 answers
Remove record from table sql
SQL
3 votes181 views1 answer
Where id is in list sql
SQL
0 vote183 views1 answer
Datatables server side filter where clause
SQL