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
MAKEDATE(year,dayofyear)
Example :
SELECT MAKEDATE(2016,34)
Output is 2016-02-03
Read more to know What is dayofyear
SELECT MAKEDATE(YEAR(CURDATE()),DAYOFYEAR(CURDATE()))
Output is 2025-02-10
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;
?>