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

16 votes242 views4 answers
Find duplicates mysql
SQL
8 votes224 views1 answer
How to remove tables from postgresql
SQL
0 vote229 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
1 vote251 views1 answer
Quit mysql
SQL
1 vote222 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
3 votes255 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
2 votes247 views1 answer
Sql finding longest and shortest names in a fleld
SQL
0 vote239 views1 answer
Mysql drop vs delete
SQL
0 vote250 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote240 views1 answer
Woocommerce mysql price table
SQL