1 2 3 4 5
| select requete.id_req,datediff(day ,requete.creation_date,requete.reception_date)as jours,
(datediff(hour ,requete.creation_date,requete.reception_date)-datediff(day ,requete.creation_date,requete.reception_date)*24)as heure,
(datediff(minute ,requete.creation_date,requete.reception_date)-datediff(hour ,requete.creation_date,requete.reception_date)*60) as minutes,
(datediff(second ,requete.creation_date,requete.reception_date)-datediff(minute ,requete.creation_date,requete.reception_date)*60) as secondes
from requete; |
Partager