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

3 votes217 views3 answers
Start postgresql ubuntu
SQL
0 vote192 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
1 vote191 views3 answers
Union in sql
SQL
0 vote194 views1 answer
Sql server port 1434
SQL
0 vote219 views1 answer
Mysql join only one column
SQL
0 vote191 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote228 views2 answers
While mysql
SQL
2 votes278 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote256 views2 answers
Suse stop MySQL
SQL
0 vote201 views1 answer
See the structure of a table mysql
SQL