-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|