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

16 votes368 views6 answers
Mysql find duplicates in same table
SQL
0 vote342 views1 answer
Consulta alias con inner join
SQL
0 vote342 views1 answer
Oracle activate program
SQL
5 votes319 views1 answer
Sql asynchronous stored procedure call
SQL
1 vote333 views1 answer
Pentaho + pasar de excel a sql
SQL
3 votes297 views1 answer
If 0 return null else return query mysql
SQL
9 votes361 views4 answers
Mysql set id auto increment
SQL
1 vote351 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
31 votes312 views3 answers
Sql count
SQL
20 votes337 views5 answers
Sql show tables
SQL