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 vote184 views1 answer
Sqlite explain plan
SQL
13 votes238 views2 answers
Sqlite rename table
SQL
4 votes164 views3 answers
Sql find second highest salary employee
SQL
0 vote154 views1 answer
Output to file mysql
SQL
0 vote175 views1 answer
Hibernate with springboot mysql
SQL
0 vote164 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote165 views1 answer
Close sql query vb.net
SQL
2 votes174 views1 answer
Possgress drop if exists table
SQL
0 vote192 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote201 views1 answer
Openquery join two tables
SQL