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

19 votes161 views3 answers
How to change column type psql
SQL
1 vote150 views2 answers
Find a column in all tables mysql
SQL
0 vote171 views1 answer
Mssql + bit + in python orm
SQL
0 vote150 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote167 views1 answer
Template MySQL Zabbix agent
SQL
0 vote189 views1 answer
Mysql sum per week
SQL
0 vote181 views1 answer
Arithmetic expression in sql
SQL
0 vote145 views1 answer
Fill up postgres db
SQL
0 vote193 views1 answer
Best sql collation
SQL
1 vote323 views3 answers
Create table from existing table in sql
SQL