1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| SELECT I.ID_INTERVENTION_SDIS Num_Inter,
S.REG_1 Categorie,
CEN.LIB_CENTRE Centre,
CEN.ID_GROUPEMENT Grpt_Centre,
YEAR(I.DH_DEBUT_INTER) Annee,
I.DH_DEBUT_INTER Date,
DATEPART(HOUR,I.DH_DEBUT_INTER) Heure
FROM OPS_SINISTRE S
INNER JOIN OPS_INTERVENTION I ON S.ID_SINISTRE=I.ID_SINISTRE
INNER JOIN OPS_CENTRE CEN ON CEN.ID_CENTRE=I.ID_CENTRE_PRINC
WHERE I.DH_DEBUT_INTER > CAST(CONVERT(VARCHAR,DATEADD(d,-1 ,GETDATE()),103)AS DATETIME)--Editer tel quel, je me retrouve avec un getdate() - 1 à 00h00
AND CEN.ID_GROUPEMENT NOT LIKE 'NR'
AND S.REG_1 NOT LIKE 'Non renseigné'
SELECT I.ID_INTERVENTION_SDIS Num_Inter,
S.REG_1 Categorie,
CEN.LIB_CENTRE Centre,
CEN.ID_GROUPEMENT Grpt_Centre,
YEAR(I.DH_DEBUT_INTER) Annee,
I.DH_DEBUT_INTER Date,
DATEPART(HOUR,I.DH_DEBUT_INTER) Heure
FROM OPS_SINISTRE S
INNER JOIN OPS_INTERVENTION I ON S.ID_SINISTRE=I.ID_SINISTRE
INNER JOIN OPS_CENTRE CEN ON CEN.ID_CENTRE=I.ID_CENTRE_PRINC
WHERE I.DH_DEBUT_INTER > CAST(CONVERT(VARCHAR,DATEADD(d,-1 ,GETDATE()),103)AS DATETIME)
AND CEN.ID_GROUPEMENT NOT LIKE 'NR'
AND S.REG_1 NOT LIKE 'Non renseigné' |
Partager