en SQL Server<\/p>\n
9294 s ==> 2.5816666 h ===> 02:34::53<\/p>\n
SELECT
\nElapsedTimeSeconds
\n,(CAST ( ElapsedTimeSeconds AS decimal(10,2))\/ 3600)
\n,RIGHT(‘0’ + CAST (FLOOR((CAST ( ElapsedTimeSeconds AS decimal(10,4))\/ 3600)) AS VARCHAR), 2) + ‘:’ +
\nRIGHT(‘0’ + CAST(FLOOR(((((CAST ( ElapsedTimeSeconds AS decimal(10,2))\/ 3600) * 3600) % 3600) \/ 60)) AS VARCHAR), 2) + ‘:’ +
\nRIGHT(‘0’ + CAST (FLOOR(((CAST ( ElapsedTimeSeconds AS decimal(10,2))\/ 3600) * 3600) % 60) AS VARCHAR), 2)
\nfrom BEDB.dbo.JobHistorySummary
\nwhere TaskTypeID = 200<\/p>\n
<\/p>\n
9294 s ==> 2.34<\/p>\n
SELECT
\nElapsedTimeSeconds
\n,(CAST ( ElapsedTimeSeconds AS decimal(10,2))\/ 3600)
\n,RIGHT(‘0’ + CAST (FLOOR((CAST ( ElapsedTimeSeconds AS decimal(10,4))\/ 3600)) AS INT), 2) + ‘.’ +
\nRIGHT(‘0’ + CAST(FLOOR(((((CAST ( ElapsedTimeSeconds AS decimal(10,2))\/ 3600) * 3600) % 3600) \/ 60)) AS VARCHAR), 2) –+ ‘:’ +
\n–RIGHT(‘0′ + CAST (FLOOR(((CAST ( ElapsedTimeSeconds AS decimal(10,2))\/ 3600) * 3600) % 60) AS VARCHAR), 2)
\n–,DATEADD(mi, (ElapsedTimeSeconds – FLOOR(ElapsedTimeSeconds)) * 60, DATEADD(hh, FLOOR(ElapsedTimeSeconds), CAST (’00:00:00’ AS TIME)))
\nfrom BEDB.dbo.JobHistorySummary
\nwhere TaskTypeID = 200<\/p>\n","protected":false},"excerpt":{"rendered":"
en SQL Server 9294 s ==> 2.5816666 h ===> 02:34::53 SELECT ElapsedTimeSeconds ,(CAST ( ElapsedTimeSeconds AS decimal(10,2))\/ 3600) ,RIGHT(‘0’ + CAST (FLOOR((CAST ( ElapsedTimeSeconds AS decimal(10,4))\/ 3600)) AS VARCHAR), 2) + ‘:’ + RIGHT(‘0’ + CAST(FLOOR(((((CAST ( ElapsedTimeSeconds AS decimal(10,2))\/ 3600) * 3600) % 3600) \/ 60)) AS VARCHAR), 2) + ‘:’ + RIGHT(‘0’ + … Continuer la lecture de « Convert secondes en heures minutes »<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[37,56],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/790"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=790"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/790\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=790"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}