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 -> Converting Numbers to Dates

Converting Numbers to Dates

From: Andy Smith <andy.smith_at_citicorp.com>
Date: 1997/03/11
Message-ID: <33254A1B.288C@citicorp.com>#1/1

-- 
I have a column in a table that stores the number of seconds
since 1970, as a number ( datatype NUMBER )

e.g

taba

col1		Null	Type
----            ----    ----
seconds                 NUMBER(15)

select * from taba;

seconds
-------
844275235
844327462   etc.


How can I convert this to a date e.g 11-MAR-1997


Appreciate any comments.


Regards
Received on Tue Mar 11 1997 - 00:00:00 CST

Original text of this message

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