THE WORLD'S LARGEST WEB DEVELOPER SITE

MySQL MAKEDATE() Function

❮ MySQL Functions

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 »

❮ MySQL Functions