This tutorial explains how to use the MySQL MAKEDATE function with syntax and examples.
The MySQL MAKEDATE function returns the date for a certain year and day-of-year value.
The syntax for the MySQL MAKEDATE function is:
The 4-digit year used to create the date.
The day of the year (greater than 0) used to create the date.
The MAKEDATE function can be used in the following versions of MySQL:
Let's look at some MySQL MAKEDATE function examples and explore how to use the MAKEDATE function in MySQL.
For example: