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

4 votes139 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote160 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
2 votes166 views2 answers
Python escape string for sql
SQL
1 vote148 views1 answer
Mysql f# examples
SQL
0 vote174 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
2 votes133 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
9 votes136 views3 answers
Mysql get last id
SQL
0 vote135 views1 answer
Group_concat only returns one row
SQL
0 vote146 views1 answer
Get primary key of table
SQL
0 vote162 views1 answer
Oracle decode
SQL