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 vote394 views1 answer
Implode in sql query
SQL
10 votes365 views2 answers
Mysql alter add foreign key
SQL
4 votes365 views1 answer
Datepart postgres
SQL
0 vote351 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
6 votes356 views2 answers
Stored procedure to delete data from table in mysql
SQL
1 vote366 views1 answer
Psql import backup file for windows
SQL
0 vote378 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote566 views3 answers
Sql subquery
SQL
6 votes333 views1 answer
Allsource oracle
SQL
8 votes359 views1 answer
Oracle search code in packages
SQL