Javatpoint Logo
Javatpoint Logo

MySQL Date/Time makedate() Function

The makedate() is a MySQL date/time function. It is used to make the date of the given year and number of days.

Syntax

Parameter:

Year : 4 digit year to find date

Number_of_days : total number of days, should be greater than zero.

Returns:

This function returns the date for a certain year and day-of-year value.

Example 1

Output:


MySQL Datetime makedate() Function

Example 2

Output:


MySQL Datetime makedate() Function
Next TopicMySQL datetime




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA