MySQLで月末とか

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

SELECT DATE_FORMAT(DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH), '%Y-%m-01');  -- 前月の月初
SELECT LAST_DAY(DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH)); -- 前月の月末

SELECT DATE_FORMAT(CURRENT_DATE, '%Y-%m-01'); -- 当月の月初

SELECT DATE_SUB(CURRENT_DATE, INTERVAL 2 DAY); -- おととい
SELECT DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY); -- 昨日

SELECT CURRENT_DATE; -- 現在

SELECT DATE_ADD(CURRENT_DATE, INTERVAL 1 DAY); -- 明日
SELECT DATE_ADD(CURRENT_DATE, INTERVAL 2 DAY); -- あさって

SELECT LAST_DAY(CURRENT_DATE); -- 当月の月末

SELECT DATE_FORMAT(DATE_ADD(CURRENT_DATE, INTERVAL 1 MONTH), '%Y-%m-01');  -- 次月の月初
SELECT LAST_DAY(DATE_ADD(CURRENT_DATE, INTERVAL 1 MONTH)); -- 次月の月末

1
2
3
4
5
6

MySQL > SELECT DATE_FORMAT(LAST_DAY(CURRENT_DATE), "%Y/%m/%d 23:59:59");
+----------------------------------------------------------+
| DATE_FORMAT(LAST_DAY(CURRENT_DATE), "%Y/%m/%d 23:59:59") |
+----------------------------------------------------------+
| 2022/02/28 23:59:59                                      |
+----------------------------------------------------------+