MAKEDATE) : Date from year and day number in MySQLReturns date by using day number ( in a year ) and year.
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.
Output is 2020-07-04
PHP ScriptTo display the above details we used PHP Script, you can use the same script for using all above queries.
This article is written by plus2net.com team.
▼ More on Date & Time functions in SQL