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 vote123 views1 answer
How to delete a record from sqlite in android
SQL
-2 votes139 views2 answers
Add auto_increment column to existing table mysql
SQL
1 vote122 views1 answer
Get url of cpanel database hostname
SQL
0 vote137 views1 answer
Oserror mysql_config not found virtualenv
SQL
1 vote173 views1 answer
Find size of all DB's postgres
SQL
19 votes126 views2 answers
Mysql add column after another
SQL
1 vote143 views1 answer
Liquibase alter column type / length
SQL
0 vote141 views1 answer
Sql select random procentage from rows
SQL
12 votes119 views3 answers
Install sqlite driver ubuntu
SQL
5 votes146 views1 answer
Oracle nls parameters
SQL