Collections:
MAKEDATE() - Making Date from Days
How to calculate the date from year and day-of-year using the MAKEDATE() function?
✍: FYIcenter.com
MAKEDATE(year, days) is a MySQL built-in function that calculates the date from year and day-of-year. For example:
SELECT MAKEDATE(2021,31), MAKEDATE(2021,32); -- +-------------------+-------------------+ -- | MAKEDATE(2021,31) | MAKEDATE(2021,32) | -- +-------------------+-------------------+ -- | 2021-01-31 | 2021-02-01 | -- +-------------------+-------------------+ SELECT MAKEDATE(2023,366), MAKEDATE(2024,366); -- +--------------------+--------------------+ -- | MAKEDATE(2023,366) | MAKEDATE(2024,366) | -- +--------------------+--------------------+ -- | 2024-01-01 | 2024-12-31 | -- +--------------------+--------------------+
Reference information of the MAKEDATE() function:
MAKEDATE(year, days): dt Returns a date, given year and day-of-year values. dayofyear must be greater than 0 or the result is NULL. Arguments, return value and availability: year: Required. The year to calculate the date from. days: Required. The number of days to be added to the year. dt: Return value. The calculated date. Available since MySQL 4.
⇒ MAKETIME() - Making Time from Components
⇐ LOCALTIMESTAMP() - Synonym for NOW()
2023-11-17, 251🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...