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 vote123 views2 answers
Drop table with constraints
SQL
1 vote90 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote96 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote94 views1 answer
Oracle list of long running queries
SQL
1 vote100 views7 answers
Filter
SQL
0 vote92 views1 answer
Faire une recherche par liste de mot clé sql
SQL
3 votes103 views3 answers
Docker create postgresql database
SQL
3 votes103 views1 answer
Laravel database Using Named Bindings
SQL
3 votes142 views2 answers
Oracle privileges users
SQL
0 vote106 views1 answer
Ksql quickstart docker
SQL