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 vote152 views1 answer
Timestamp in sqlite
SQL
0 vote168 views1 answer
For row in sql database python loop
SQL
1 vote152 views2 answers
Datetrunc hour snowflake
SQL
0 vote137 views1 answer
How to search query in python3 sqlite3
SQL
2 votes215 views2 answers
How to DROP a table in mysql
SQL
0 vote99 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
8 votes118 views1 answer
Oracle current date plus 1 month
SQL
5 votes157 views1 answer
Oracle asynchronous update
SQL
0 vote157 views2 answers
Temp Space
SQL
0 vote187 views1 answer
Display all node label neo4j
SQL