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 vote289 views4 answers
Postgres extract date from timestamp
SQL
1 vote284 views1 answer
Add constraint sql
SQL
0 vote294 views1 answer
Match end of string regex sql
SQL
0 vote305 views1 answer
Postgres list all stored procedures query
SQL
0 vote322 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
4 votes362 views2 answers
Sql display today's date
SQL
0 vote290 views1 answer
Sql server cannot create database diagram
SQL
0 vote323 views2 answers
Mysql two column combination unique
SQL
0 vote288 views1 answer
Except in sql alchemy
SQL
0 vote299 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL