SA Developer .NET

Hi all...can any1 plz assist me with converting this value "86400000" milliseconds into hours and minutes

---

Livin life on da flip side

This should work. It takes advantage of the integer division in SQL, that's why there's an apparently pointless divide and multiply in the second clause

DECLARE @Milliseconds INT,
    @Minutes INT
SET @Milliseconds = 86400000
SET @Minutes = @Milliseconds/60000

select @Minutes/60 AS Hours, @Minutes - (@Minutes/60)*60 AS Minutes

---

Gail Shaw - SQL In the Wild
SQL Server MVP
--
Chaos, panic and disorder. My job here is done!