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

5 votes349 views2 answers
Add column postgres with default value
SQL
0 vote393 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote347 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote409 views1 answer
T-sql disable system versioning
SQL
0 vote413 views1 answer
Sql alternative to max statement
SQL
0 vote344 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote339 views1 answer
Sql server remove 0 from left
SQL
0 vote342 views1 answer
Sqlite referential integrity
SQL
0 vote350 views4 answers
Best data type to represent money in mysql
SQL
1 vote347 views1 answer
Sql delete row with auto increment
SQL