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

22 votes360 views1 answer
Mysql workbench
SQL
-2 votes278 views1 answer
Mysql not empty
SQL
0 vote274 views1 answer
How to save data in database in mysql node
SQL
0 vote282 views1 answer
Opensuse stop MySQL
SQL
0 vote282 views1 answer
Incorrect string value: mysql
SQL
37 votes281 views3 answers
Postgresql insert column
SQL
1 vote289 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
5 votes341 views1 answer
Oracle ora-00054 find
SQL
14 votes299 views5 answers
Sql oracle limit
SQL
0 vote256 views1 answer
Mysql create table columns with spaces
SQL