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

16 votes108 views1 answer
Sqlserver add column to table
SQL
0 vote120 views1 answer
Html css mobile menu arrow dropdown
SQL
5 votes108 views1 answer
Mysql get last day of month
SQL
49 votes202 views6 answers
Mysql add column to table
SQL
0 vote117 views1 answer
Oracle procedure chain step
SQL
0 vote123 views1 answer
Mysql procedure between two tables
SQL
7 votes115 views2 answers
Mysql db size
SQL
0 vote123 views1 answer
Oracle procedure teamplate
SQL
0 vote125 views1 answer
Postgresql list extensions
SQL
0 vote115 views1 answer
Mysql installer no packages found
SQL