MySQL MAKEDATE() Function
Example
Create and return a date based on a year and a number of days value:
SELECT MAKEDATE(2017, 3);
Try it Yourself »
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 |
|---|
More Examples
Example
Create and return a date based on a year and a number of days value:
SELECT MAKEDATE(2017, 175);
Try it Yourself »
Example
Create and return a date based on a year and a number of days value:
SELECT MAKEDATE(2017, 100);
Try it Yourself »
Example
Create and return a date based on a year and a number of days value:
SELECT MAKEDATE(2017, 366);
Try it Yourself »
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.