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

23 votes215 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes229 views3 answers
Restart mysql mac
SQL
0 vote220 views2 answers
How to find max and min salary in sql
SQL
0 vote223 views1 answer
Where in clause tsql
SQL
1 vote229 views1 answer
Python clean sql string
SQL
0 vote241 views1 answer
How to find columns with null values in sql
SQL
1 vote224 views1 answer
Oracle lock user
SQL
0 vote219 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
16 votes228 views4 answers
Mysql import from sql file
SQL
5 votes234 views1 answer
Sort order on two columns sql
SQL