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).
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 themakeDate(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.