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 vote265 views1 answer
Mariadb errno 121
SQL
0 vote288 views1 answer
Postgresql inheritance
SQL
1 vote278 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote245 views1 answer
What is the essence of SQL?
SQL
0 vote259 views1 answer
Setval postgres example table id
SQL
0 vote256 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
6 votes293 views2 answers
Foreign key sqlite3 python
SQL
5 votes267 views1 answer
Oracle get foreign keys on table
SQL
0 vote261 views1 answer
Drop specific row postgresql
SQL
0 vote271 views1 answer
Select insert new table sql server
SQL