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 vote209 views1 answer
How to change null display in psql
SQL
4 votes211 views2 answers
Installing sql on ubuntu
SQL
-1 vote176 views1 answer
Mysql if example
SQL
0 vote207 views2 answers
How to start postgresql laravel
SQL
1 vote228 views3 answers
How to pass password to mysql command line
SQL
0 vote195 views1 answer
Get records in sql according to month name and count
SQL
0 vote215 views1 answer
Sql tablo hangi sp de
SQL
3 votes210 views2 answers
Mysql create timestamp column
SQL
7 votes201 views1 answer
Alter sequence set current value oracle
SQL
1 vote211 views1 answer
Oracle sql first day of year
SQL