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 vote163 views1 answer
Sql select without column name
SQL
-1 vote108 views1 answer
Export mysql table to file
SQL
1 vote102 views1 answer
Mysql server does not start mac
SQL
13 votes119 views2 answers
Get tables in database sql
SQL
10 votes119 views1 answer
User_dependencies
SQL
0 vote116 views1 answer
Sql query to select records entered in last 24 hours
SQL
4 votes105 views3 answers
Create database in mySQL
SQL
0 vote121 views1 answer
Drop-toys-table
SQL
1 vote115 views1 answer
Mysql select update same table
SQL
0 vote127 views1 answer
Sqlite trim
SQL