Translations:Faq/Base/120/8/fr

    From The Document Foundation Wiki

    SELECT "ID", "Heure_Debut", "Heure_Fin", TO_CHAR( CAST ( '00:' || DATEDIFF( 'mi', "Heure_Debut", "Heure_Fin" ) || ':00' AS "TIME" ), 'HH:MI' ) AS "Durée" FROM "Table1"