DAYOFYEAR() : Day number of the year in MySQLReturns full day name from a date.
Output is 147
CURDATE() or NOW() & DAYOFYEAR()By using CURDATE() we get the present date part only, where as by using NOW() we will get both date and time.
Output is 186
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