| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Data Conversion Problem
--
I have a table TAB1, with one column COL1, datatype NUMBER
select COL1 from TAB1;
COL1
----------
5373484
1 rows selected.
How do I convert 5373484 to HH24, assuming 5373484 is the number
of days ??
Appreciate any ideas.
=================================================================
Andy Email: andy.smith_at_citicorp.com
Received on Fri Jan 03 1997 - 00:00:00 CST
![]() |
![]() |