1 2 3
| SELECT TO_CHAR( CAST( '00:' || DATEDIFF( 'mi', "Heure In 1", "Heure Out 1" ) || ':00' AS "TIME" ), 'HH:MI' ) "Temps 1", TO_CHAR( CAST( '00:' || DATEDIFF( 'mi', "Heure In 2", "Heure Out 2" ) || ':00' AS "TIME" ), 'HH:MI' ) "Temps 2", TO_CHAR( CAST( '00:' || DATEDIFF( 'mi', "Heure In 3", "Heure Out 3" ) || ':00' AS "TIME" ), 'HH:MI' ) "Temps 3", TO_CHAR( CAST( '00:' || DATEDIFF( 'mi', "Heure In 4", "Heure Out 4" ) || ':00' AS "TIME" ), 'HH:MI' ) "temps 4", TO_CHAR( CAST( '00:' || DATEDIFF( 'mi', "Heure In 5", "Heure Out 5" ) || ':00' AS "TIME" ), 'HH:MI' ) "Temps 5", TO_CHAR( CAST( '00:' || DATEDIFF( 'mi', "Heure In 6", "Heure Out 6" ) || ':00' AS "TIME" ), 'HH:MI' ) "Temps 6",
DATEDIFF( 'mi', "Heure In 1", "Heure Out 1" ) + DATEDIFF( 'mi', "Heure In 2", "Heure Out 2" ) + DATEDIFF( 'mi', "Heure In 3", "Heure Out 3" ) + DATEDIFF( 'mi', "Heure In 4", "Heure Out 4" ) + DATEDIFF( 'mi', "Heure In 5", "Heure Out 5" ) + DATEDIFF( 'mi', "Heure In 6", "Heure Out 6" ) "TPS_TOTAL"
FROM "lieu de contrôle" |