Login

Example

Create and return a date based on  a year and a number of days value:

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

More Examples

Example

Create and return a date based on  a year and a number of days value:

SELECT MAKEDATE(2017, 175);

Example

Create and return a date based on  a year and a number of days value:

SELECT MAKEDATE(2017, 100);

Example

Create and return a date based on  a year and a number of days value:

SELECT MAKEDATE(2017, 366);

Login
ADS CODE