Returns date by using day number ( in a year ) and year.
Syntax
MAKEDATE(year,dayofyear)
Example :
SELECT MAKEDATE(2016,34)
Output is 2016-02-03
Read more to know What is dayofyear
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 2023-06-07
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;
?>
← Subscribe to our YouTube Channel here
SQL Video Tutorials