Blog

In this guide, we will explain how to use the MySQL MAKEDATE function with syntax and examples.

Description

The MySQL MAKEDATE function returns the date for a certain year and day-of-year value.

Syntax

The syntax for the MAKEDATE function is:

MAKEDATE( year, day-of-year )

Parameters or Arguments

year

The 4-digit year used to create the date.

day-of-year

The day of the year (greater than 0) used to create the date.

Note

• If day-of-year is less than 1, the MAKEDATE function will return NULL.

Applies To

The MAKEDATE function can be used in the following versions :

• MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1.1

Example

Let’s look at some MAKEDATE function examples and explore how to use the MAKEDATE function.

For example:

mysql> SELECT MAKEDATE(2014,1);
        -> '2014-01-01'

mysql> SELECT MAKEDATE(2014,31);
        -> '2014-01-31'

mysql> SELECT MAKEDATE(2014,32);
        -> '2014-02-01'

mysql> SELECT MAKEDATE(2014,200);
        -> '2014-07-19'

mysql> SELECT MAKEDATE(2014,365);
        -> '2014-12-31'

mysql> SELECT MAKEDATE(2014,366);
        -> '2015-01-01'

Next Topic : Click Here