Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Seconds
Hi
I have a test table. 1 of the columns hav time in second as follows :
Seconds
10720
31
30
31
30
11
20
10
4
2459
I want the data in a new column T in hh24:mm:ss
plz help
thanks in advance :) Received on Fri Mar 24 2006 - 08:48:49 CST