Example
SELECT MAKEDATE(2017, 3);Definition and Usage
The MAKEDATE() function creates and returns a date based on a year and a number of days value.
Syntax
MAKEDATE(
year
,
day
)Parameter Values
| Parameter | Description |
|---|---|
| year | Required. A year (4-digits) |
| day | Required. A number that indicates the day of the year |
Technical Details
| Works in: | From MySQL 4.0 |
|---|