MAKEDATE() function to get date from dayofyear() and Year as inputs in MySQL Query

SELECT MAKEDATE(2023,5); # 2023-01-05
SELECT MAKEDATE(2023,365); # 2023-12-31
SELECT MAKEDATE(2024,365); #2024-12-30
SELECT MAKEDATE(2024,369); # 2025-01-03

Year 2024 is a leap year

Returns date by using day number ( of a year ) and year.
Syntax

MAKEDATE(year,dayofyear)

Example :

SELECT MAKEDATE(2016,34)

Output is 2016-02-03

CURDATE() YEAR()

By using CURDATE() we get the present date part, by using YEAR() we will get YEAR. Here is a query with all these functions.

SELECT MAKEDATE(YEAR(CURDATE()),DAYOFYEAR(CURDATE()))

Output is 2026-09-09

PHP Script

To display the above details we used PHP Script, you can use the same script for using all above queries.

config.php connection string is available here

PDO for executing Queries in PHP

How to get records using FETCH() are here

<?Php
require 'config.php';  // Database connection string
$query='SELECT MAKEDATE(YEAR(CURDATE()),DAYOFYEAR(CURDATE()) )as dt';
// Change the above Query part to get different results // 

$count=$dbo->prepare($query);
$count->execute();
$row = $count->fetch(PDO::FETCH_OBJ);
echo 'Output is : '.$row->dt; 
?>

DATEOFYEAR() : Number of day in a year

SQL Date References MONTH() DAY() NOW() : Current Date with Time

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

MAKEDATE() : Date from year and day number

CURDATE() YEAR()

PHP Script

Subhendu Mohapatra