If I understand the question and fieldname contains a time measured as
elapsed seconds from 01/10/1970 the try
select to_date((fieldname/86400)+to_date('01/01/1970','dd/mm/yyyy')) from
dual;
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Marc[uk]" <top_marcREMOVE_at_hotmail.com> wrote in message
news:1029933302.14131.0.nnrp-08.c2decc6c_at_news.demon.co.uk...
> Hi,
>
> I have a requirement to display data from an Oracle 8.1.7 table which is
> populated by a 3rd party application. This application happens to store
all
> of it's dates in the database as UNIX time (in seconds) but to make this
> meaningful in the report, i need to display it as GMT.
>
> I could do this in SQL Server with the line
>
> DATEADD (ss,<fieldname>,'19700101')
>
> but the closest function I found to this in Oracle is ADD_MONTHS.. but I
> assume by the name of the function, this works only in months whereas I
need
> to convert from seconds.
>
> Any ideas?
>
> regards,
>
> Marc[uk]
>
>
>
>
Received on Wed Aug 21 2002 - 08:56:45 CDT
