Answers for "mysql end of month"

SQL
5

mysql get last day of month

SELECT LAST_DAY(CURDATE());						-- Current month
SELECT LAST_DAY(CURDATE() - INTERVAL 1 MONTH);	-- Previous month
SELECT LAST_DAY(CURDATE() + INTERVAL 1 MONTH);	-- Next month
Posted by: Guest on May-21-2021
1

mysql select month and year

SELECT DATE_FORMAT(test_date,'%Y%m') AS date FROM test_table;
Posted by: Guest on April-27-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language