MAKEDATE() : Date from year and day number in MySQLSyntax
Example :
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.
Output is 2023-06-07
PHP ScriptTo 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
Subscribe to our YouTube Channel here
This article is written by plus2net.com team.
https://www.plus2net.com
![]() ▼ More on Date & Time functions in SQL |