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

8 votes134 views1 answer
Oracle search source code
SQL
0 vote144 views1 answer
Disable database droping sql
SQL
0 vote131 views1 answer
Set default value now() date
SQL
0 vote137 views1 answer
Mysql trim characters
SQL
1 vote141 views1 answer
Float precision in psql
SQL
0 vote136 views1 answer
Postgres in operator with comma separated values
SQL
11 votes208 views2 answers
Sql between date range
SQL
0 vote161 views1 answer
Alter database name script
SQL
244 votes247 views14 answers
Sql n insert
SQL
0 vote173 views1 answer
Count column of tables psql
SQL