Dates

These functions are used to parse and manipulate DATE inputs.

Functions

convert_date_to_date_id

Attribute	Value
Name	convert_date_to_date_id
ID	bqtools.[region].convert_date_to_date_id
Description	Converts a DATE value to a date_id STRING.
Type	FUNCTION
Arguments	date DATE
Returns	STRING
Dependencies	None

execution: convert_date_to_date_id

EUUS

SELECT bqtools.eu.convert_date_to_date_id(date);

SELECT bqtools.us.convert_date_to_date_id(date);

convert_date_id_to_date

Attribute	Value
Name	convert_date_id_to_date
ID	bqtools.[region].convert_date_id_to_date
Description	Converts a date_id STRING DATE value to a .
Type	FUNCTION
Arguments	date DATE
Returns	STRING
Dependencies	None

execution: convert_date_id_to_date

EUUS

SELECT bqtools.eu.convert_date_id_to_date(date);

SELECT bqtools.us.convert_date_id_to_date(date);

generate_date_id_array

Attribute	Value
Name	generate_date_id_array
ID	bqtools.[region].generate_date_id_array
Description	Builds an array of date_ids between a start_date and end_date.
Type	FUNCTION
Arguments	start_date DATE, end_date DATE
Returns	ARRAY<STRING>
Dependencies	None

execution: generate_date_id_array

EUUS

SELECT bqtools.eu.generate_date_id_array(start_date, end_date);

SELECT bqtools.us.generate_date_id_array(start_date, end_date);