LOGIN
Tuesday, May 6, 2025
Top Posts
SUBSCRIBE NEWSLETTERS
Home » MySQL makedate() Function
MySQL Date/Time FunctionsMysql Tutorial

MySQL makedate() Function

by Online Tutorials Library

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

You may also like

MySQL String MID() Function

MySQL String OCTET_LENGTH() Function

MySQL String POSITION() Function

MySQL String LEFT() Function

MySQL String LENGTH() Function

MySQL String LOWER() Function