Collections:
DAYOFYEAR() - Day of Year
How to extract the day of year of a given date using the DAYOFYEAR() function?
✍: FYIcenter.com
DAYOFYEAR(date) is a MySQL built-in function that returns the day of year from a given date. For example:
SELECT DAYOFYEAR('2023-02-03'), DAYOFYEAR(NOW()); -- +-------------------------+------------------+ -- | DAYOFYEAR('2023-02-03') | DAYOFYEAR(NOW()) | -- +-------------------------+------------------+ -- | 34 | 318 | -- +-------------------------+------------------+
Reference information of the DAYOFYEAR() function:
DAYOFYEAR(date): int Returns the day of the year for date, in the range 1 to 366. Arguments, return value and availability: date: Required. The date to extract the day of year from. int: Return value. The day of year. Available since MySQL 4.
Related MySQL functions:
⇒ EXTRACT() - Extracting Datetime Component
⇐ DAYOFWEEK() - Day of Week (1=Sunday)
2023-11-16, 257🔥, 0💬
Popular Posts:
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...