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

4 votes165 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote188 views1 answer
Rename view mysql
SQL
0 vote197 views1 answer
Create a view in sqlite
SQL
0 vote166 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote183 views1 answer
Where date in datetime mysql
SQL
7 votes176 views2 answers
Add column table pl sql
SQL
0 vote194 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote193 views1 answer
Logtash mysql cofiguration file
SQL
0 vote179 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote189 views1 answer
Convert polygon to text in mysql
SQL