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 vote261 views1 answer
Where date in datetime mysql
SQL
1 vote254 views2 answers
Sql drop multiple columns if exists
SQL
0 vote240 views1 answer
Add plugins to mysql workbench
SQL
0 vote257 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote284 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
3 votes282 views6 answers
Jwt laravel
SQL
1 vote243 views1 answer
Sql only five first row
SQL
0 vote272 views1 answer
Lost connection to mysql
SQL
0 vote247 views1 answer
Sql remove first character from string
SQL
25 votes250 views1 answer
Mysql grant all privileges to a user
SQL