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 vote126 views1 answer
Kannst du deine finger trainieren
SQL
0 vote228 views1 answer
Postgres get running query
SQL
0 vote190 views1 answer
Play framework connection via windows sql server
SQL
1 vote212 views1 answer
Oracle drop chain step
SQL
0 vote184 views1 answer
Alter rename command in mysql
SQL
0 vote171 views1 answer
Char varchar nvarchar sql
SQL
0 vote187 views1 answer
How to select even id in sql
SQL
0 vote197 views1 answer
Into operator in sql
SQL
5 votes165 views1 answer
Invalid column name sql
SQL
2 votes165 views1 answer
How to add where command in update comand with joins
SQL