how do i convert milliseconds into hr:mi:ss format

Hi,
How do i convert milliseconds into hr:mi:ss format both in oracle and sqlserver.
eg: i have 140000 milliseconds ,how can i convert that into hr:mi:s format.
what is the query for this and is there a common query which works both for oracle and sqlserver database.
I am using oracle 8x and sqlserver 2000.
Thanks in advance
kolli

I dont know it this work in SQLServer, but in Oracle you can do:

select to_char (to_date(round(140000/1000), 'SSSSS' ), 'HH24:MI:SS') AS HMS from dual;

If you have more than 86399 seconds (seconds in a day) you must modify de sentence to detect that and add 24 hours to the result.

Best regards.

Ignacio