Dates & time Scalar

make_date()

The date for the given struct.

Reference: DuckDB 2.0.0

Arguments & returns

3 overloads

make_date(date-struct)

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

make_date(days)

Scalar
Overload link days Returns
#02 INTEGER DATE

make_date(year, month, day)

Scalar

The date for the given parts.

Overload link yearmonthday Returns
#03 BIGINTBIGINTBIGINT DATE
make_date example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

More examples

make_date example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

BigQuerydate()

SELECT DATE(2024, 1, 15)
In DuckDB
SELECT MAKE_DATE(2024, 1, 15)

SQLGlot example ↗

Snowflake

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

SQLGlot example ↗