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 vote179 views2 answers
Alter table add multiple columns mysql
SQL
0 vote162 views1 answer
Sql get month and year from date
SQL
1 vote188 views1 answer
Sql count value greater than
SQL
0 vote195 views1 answer
Postgres clear table
SQL
0 vote221 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote228 views1 answer
SQL get max per id
SQL
11 votes194 views1 answer
Sql insert multiple rows from select
SQL
0 vote188 views1 answer
Mssql dockere
SQL
1 vote192 views1 answer
Sql random sampling per group
SQL
0 vote186 views1 answer
Create column that already exists mysql
SQL