Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Data Conversion Problem

Data Conversion Problem

From: Andy Smith <andy.smith_at_citicorp.com>
Date: 1997/01/03
Message-ID: <32CD3CA7.3AFA@citicorp.com>#1/1

-- 
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US