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 vote337 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
1 vote346 views1 answer
Key validation sql
SQL
2 votes334 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote313 views1 answer
Automatically update database last seen datetime in sql
SQL
15 votes585 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote265 views1 answer
Oracle last user logon
SQL
2 votes325 views1 answer
Change primary key sql
SQL
0 vote316 views1 answer
Psql check if value in array
SQL
0 vote346 views1 answer
Procedure excute monthly oracle
SQL
0 vote330 views1 answer
Using distinct and count together in sql
SQL