Collections:
LAST_DAY() - Last Day of Month
How to convert a date to the month-end date using the LAST_DAY() function?
✍: FYIcenter.com
LAST_DAY(date) is a MySQL built-in function that returns the month-end date from a given date. For example:
SELECT LAST_DAY('2020-02-14'), LAST_DAY(NOW()), NOW(); -- +------------------------+-----------------+---------------------+ -- | LAST_DAY('2020-02-14') | LAST_DAY(NOW()) | NOW() | -- +------------------------+-----------------+---------------------+ -- | 2020-02-29 | 2023-11-30 | 2023-11-15 08:33:35 | -- +------------------------+-----------------+---------------------+
Reference information of the LAST_DAY() function:
LAST_DAY(date): dt Takes a date or datetime value and returns the corresponding value for the last day of the month. Returns NULL if the argument is invalid. Arguments, return value and availability: date: Required. The date to be converted from. dt: Return value. The month-end date. Available since MySQL 4.
⇒ LOCALTIME() - Synonym for NOW()
2023-11-17, 260🔥, 0💬
Popular Posts:
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...