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

8 votes359 views10 answers
Sql
SQL
0 vote289 views1 answer
Postgresql add leading zeros
SQL
0 vote339 views1 answer
Sqlite update where exists
SQL
-2 votes335 views1 answer
Create trigger syntax
SQL
2 votes368 views3 answers
Postgres create view
SQL
1 vote333 views1 answer
Set statistics on in ssms
SQL
1 vote331 views1 answer
Oracle list constraints
SQL
7 votes380 views1 answer
Mysql remote connection command line
SQL
1 vote500 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
4 votes349 views1 answer
SQL find text in SP
SQL