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, 264🔥, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...