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 vote287 views1 answer
Delete data from database sqlite android
SQL
0 vote270 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote285 views1 answer
Import sql in postgresql
SQL
0 vote269 views1 answer
Call function in query sql server
SQL
4 votes272 views2 answers
Mysql show indexes on table
SQL
0 vote268 views1 answer
Query on date sqlite flutter
SQL
0 vote288 views1 answer
How to list function in psql
SQL
13 votes289 views2 answers
Sql join 3 tables
SQL
0 vote273 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote279 views1 answer
Select from describe sql
SQL