Select the first and last day of the previous month

Question

Select the first and last day of the previous month

Navigation

#1 by (3 votes)
#2 by (0 votes)

2

I have the following query :

select  
ADDDATE(LAST_DAY(SUBDATE(CURDATE(), INTERVAL 1 MONTH)), 1) primeiro_dia, 
last_day(sysdate()) ultimo_dia

That returns me the first and last day of the current month according to the system date. How could I return the first and last day of the previous month according to the system date too?

mysql sql

asked by anonymous 04.06.2018 / 14:29

2 answers

0

SELECT 
   DATE_ADD(LAST_DAY(NOW() - INTERVAL 2 MONTH), INTERVAL 1 DAY) primeiro_dia_mes_anterior,
   (LAST_DAY(NOW() - INTERVAL 1 MONTH)) ultimo_dia_mes_anterior

04.06.2018 / 14:59

Line wrap control does not work "white-space: nowrap:" Screen suitability is not doing its function "@media screen and () {}"

score 3 · Accepted Answer

Given the query you already have, just fetch the same data by subtracting from the date a month:

select
   ADDDATE(LAST_DAY(SUBDATE(CURDATE(), INTERVAL 1 MONTH)), 1) primeiro_dia, 
   last_day(sysdate()) ultimo_dia,
   ADDDATE(LAST_DAY(SUBDATE(DATE_SUB(curdate(), INTERVAL 1 MONTH), INTERVAL 1 MONTH)), 1) primeiro_dia_mes_passado, 
   last_day(DATE_SUB(curdate(), INTERVAL 1 MONTH)) ultimo_dia_mes_passado