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

14 votes332 views1 answer
Oracle new column
SQL
-1 vote323 views1 answer
Module operator in oracle sql
SQL
4 votes272 views3 answers
Create table if not exists postgresql
SQL
1 vote328 views1 answer
How to remove identity from a column in sql server
SQL
0 vote363 views1 answer
Delete from IN subquery
SQL
1 vote313 views3 answers
How to truncate foreign key constraint table
SQL
0 vote337 views1 answer
Prodection ready postgres database step by step
SQL
23 votes340 views4 answers
How to show all users in mysql
SQL
0 vote317 views1 answer
Sql select min
SQL
0 vote323 views1 answer
SQL Server rename foreign key constraint
SQL