1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
|
WITH
date_releve as (select
a.reference,
concat(SUBSTR(a.date_releve, 7, 4),'/',SUBSTR(a.date_releve, 4, 2),'/',SUBSTR(a.date_releve, 1, 2)) AS date_releve_mois
from phases a),
date_pma as (select reference,
date(str_to_date(date_releve_mois, '%Y/%m/%d')) as date_releve_pma
from date_releve)
select a.reference, b.date_releve_pma, date(date_releve_pma - '1 month') as date_pma_reel
from date_releve a
left join date_pma b on a.reference = b.reference
and a.date_releve_mois = b.date_releve_pma |
Partager