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