1 2 3 4 5 6 7 8 9 10 11 12 13
|
SELECT DISTINCT A.AGENT, A.NOM, A.PRENOM,
DATE_FORMAT(A.DATE_JOUR,'%d/%m/%Y') AS JOUR,
A.EVT, A.Dat_deb, A.H_deb, A.Dat_fin, A.H_fin,A.Duree,
A.Competence, A.No_Ent, A.No_Sort, A.Tps_Pause,
A.Tps_Live, A.Tps_Log, A.Tps_SupAg
FROM jour_agent A, person_team p
WHERE p.ID_sib = A.AGENT
and p.ID_TEAM='7'
AND A.EVT='LOGIN'
AND A.Date_JOUR BETWEEN '20090901000000' and '20090901999999'
and date_format(date_jour, '%H%i%S') between '000000' and '235959'
ORDER BY A.NOM, A.DATE_JOUR, A.H_deb |
Partager