Dates & time Scalar

make_date()

The date for the given struct.

Arguments & returns

3 overloads

Scalar

Overload link	`col0`	Returns
#01	`INTEGER`	`DATE`

Scalar

Overload link	`date-struct`	Returns
#02	`STRUCT("year" BIGINT, "month" BIGINT, "day" BIGINT)`	`DATE`

Scalar

The date for the given parts.

Overload link	`year`	`month`	`day`	Returns
#03	`BIGINT`	`BIGINT`	`BIGINT`	`DATE`

SELECT make_date({'year': 2024, 'month': 11, 'day': 14});

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT make_date(1992, 9, 20);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT DATE(2024, 1, 15)

In DuckDB

SELECT MAKE_DATE(2024, 1, 15)

LAST_DAY(CAST('2024-06-15' AS DATE), YEAR)

In DuckDB

MAKE_DATE(EXTRACT(YEAR FROM CAST('2024-06-15' AS DATE)), 12, 31)