ok maintenant le compliquer cest le sum
la requet qui fait le sum pour moi elle existe, je l'est déja fait et elle fonctionne bien:
SELECT TO_CHAR(TRUNC(SUM(TO_CHAR(to_date(total_wor, 'HH24:MI:ss'),'sssss'))/3600)) || ':' || TO_CHAR(TRUNC(MOD(SUM(TO_CHAR(to_date(total_wor, 'HH24:MI:ss'),'sssss')), 3600)/60)) || ':' || TO_CHAR(MOD(SUM(TO_CHAR(to_date(total_wor, 'HH24:MI:ss'),'sssss')), 60)) FROM works
mais ma requete global ne marche pas:
select user_wor,name_pro, name_tas, name_sta,TO_CHAR(TRUNC(SUM(TO_CHAR(to_date(total_wor, 'HH24:MI:ss'),'sssss'))/3600)) || ':' || TO_CHAR(TRUNC(MOD(SUM(TO_CHAR(to_date(total_wor, 'HH24:MI:ss'),'sssss')), 3600)/60)) || ':' || TO_CHAR(MOD(SUM(TO_CHAR(to_date(total_wor, 'HH24:MI:ss'),'sssss')), 60)) FROM works GROUP BY name_pro, name_tas
un coup de main
Partager