Dates & time
Scalar
make_date()
The date for the given struct.
Reference: DuckDB 2.0.0
Arguments & returns
3 overloadsmake_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 | year | month | day |
Returns |
|---|---|---|---|---|
| #03 | BIGINT | BIGINT | BIGINT |
DATE |
Example
1 more ↓Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.
More examples
Haybarn WASM 2.0.0-rc12 · In your browser
Engine example · Run to view results.
In other engines
Snowflake
LAST_DAY(CAST('2024-06-15' AS DATE), YEAR)
MAKE_DATE(EXTRACT(YEAR FROM CAST('2024-06-15' AS DATE)), 12, 31)