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

14 votes342 views2 answers
How to auto increment in sql
SQL
4 votes362 views1 answer
Restart for pg_hba.conf file
SQL
7 votes375 views4 answers
What is my mysql version
SQL
12 votes343 views1 answer
How to change the value of a table in sql
SQL
0 vote333 views0 answer
SQL
0 vote352 views1 answer
Limit and offset in stored procedure mssql
SQL
7 votes364 views2 answers
Html to react converter
SQL
1 vote359 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote339 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote409 views1 answer
Sql set data from a select query to a temp table and insert
SQL