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

0 vote364 views1 answer
Mysql remove bad character from all fields
SQL
2 votes280 views1 answer
Sql float to int
SQL
0 vote327 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote365 views1 answer
Postgresql check total storage
SQL
0 vote348 views1 answer
Sql server beginning of month
SQL
0 vote328 views2 answers
Return the number of records in a single table mysql
SQL
1 vote332 views1 answer
Sql server get users
SQL
4 votes316 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
2 votes337 views1 answer
Mysql query unique column
SQL
0 vote374 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL