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 vote207 views1 answer
Postgres sequence name
SQL
0 vote185 views1 answer
How to retrive the today date sql
SQL
6 votes199 views3 answers
Date_trunc postgres
SQL
1 vote204 views1 answer
Sysdate in sql
SQL
0 vote198 views1 answer
Sql last 3 rows
SQL
24 votes205 views4 answers
Delete db postgres
SQL
4 votes188 views4 answers
Print pl sql
SQL
3 votes207 views2 answers
Monthname sql
SQL
0 vote190 views1 answer
Recover deleted data from mysql database
SQL
0 vote201 views1 answer
Flask sqlalchemy session delete
SQL