v.23.5Improvement

Function "makeDate" Now Supports MySQL-Compatible Overload

Function "makeDate" now provides a MySQL-compatible overload (year & day of the year argument). #49603 (Robert Schulze).
The makeDate function now supports a MySQL-compatible overload that accepts a year and day of the year as arguments.

Why it matters

This feature allows users to create dates from a year and the day number within that year, matching MySQL's behavior. It simplifies migration and interoperability for users familiar with MySQL date functions and enables more flexible date construction based on ordinal day values.

How to use it

Use the makeDate(year, day_of_year) function by passing the year as the first argument and the day of the year as the second argument, for example: makeDate(2024, 150) to get the 150th day of 2024.