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

1 vote360 views2 answers
Laravel jwt generate token
SQL
0 vote309 views3 answers
Sql server import json
SQL
0 vote320 views1 answer
How to check which table has data in mysql
SQL
0 vote288 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
5 votes305 views3 answers
How to remove unique key constraint in mysql
SQL
10 votes309 views1 answer
User_dependencies
SQL
0 vote307 views1 answer
Linebreak sql
SQL
0 vote318 views1 answer
Add sqlcmd to path linux
SQL
1 vote291 views2 answers
Mysql does sentance contain word
SQL
1 vote306 views1 answer
Mariadb case switch
SQL