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 vote266 views1 answer
Oracle search columns in schema
SQL
16 votes283 views3 answers
Jwt secret key generator laravel
SQL
0 vote287 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote292 views1 answer
Search from comma separated values in sql server
SQL
0 vote285 views2 answers
Postgresql change user role grant
SQL
0 vote262 views1 answer
The local psql command could not be located
SQL
1 vote292 views1 answer
Print all records of table in mysql
SQL
0 vote269 views1 answer
Sql beginning of previous month
SQL
1 vote294 views1 answer
Sql server loop over query
SQL
0 vote268 views1 answer
How to print records of employees hired in particular month in oracle
SQL