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 vote203 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote210 views2 answers
2nd max salary query in sql
SQL
0 vote214 views1 answer
Sql anywhere create procedure
SQL
0 vote217 views1 answer
R2dbc-postgresqldriver dependency
SQL
1 vote208 views1 answer
Not exists mysql
SQL
0 vote231 views1 answer
Check user sql password from command line
SQL
0 vote217 views1 answer
Mysql grant grant option
SQL
0 vote220 views1 answer
Frename oracle
SQL
0 vote227 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote240 views1 answer
Add two days to current date in sql when creating tables
SQL