(Resolvido) Select do mês do anterior

[luis Romao 0]

Olá pessoa,

Preciso da ajuda para consultar os registros do mês anterior sem a necessidade de informar datas

Em Mysql eu consigo fazer.

where (
    (month(`arte`.`artedataregistro`) = month(curdate())-1) and 
    (year(`arte`.`artedataregistro`) = year(curdate()))
)

Como fazer em Postgres? Edited February 24, 2015 by Kakao

[Kakao 0]

where
    date_trunc('month', arte.artedataregistro) =
    date_trunc('month', current_date - interval '1 month')

Edited February 24, 2015 by Kakao

[Dr. House 0]

where
extract(month from data) = X
and
extract(year from data) = xxxx

[luis Romao 0]

Deu certo, muito obrigado!!

[Dr. House 0]

qual dos 2?

[luis Romao 0]

where
date_trunc('month', arte.artedataregistro) =
date_trunc('month', current_date - interval '1 month')

[Maycon Noetzold 0]

WITH INTERVALO_30 AS(
    SELECT CAST(EXTRACT(YEAR FROM CURRENT_DATE-30)||'-'||EXTRACT(MONTH FROM CURRENT_DATE-30)||'-01' AS DATE) AS DATA_INI,
            (DATE_TRUNC('MONTH', CURRENT_DATE-30) + INTERVAL '1 MONTH - 1 DAY')::DATE AS DATA_FIM
)
SELECT DATA_INI, DATA_FIM
  FROM INTERVALO_30