Re: Converting UNIX time to GMT

Regardless of the source, if it's stored in the database then it's stored as an Oracle DATE data type. So you could, provided you know the originating TIMEZONE use something like:

to_char(new_time(your_date_field, 'CST', 'GMT'), 'DD-Month-YYYY HH24:MI')

James

"Marc[uk]" <top_marcREMOVE_at_hotmail.com> wrote in message news:1029925147.10683.0.nnrp-08.c2decc6c_at_news.demon.co.uk...
> 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 - 07:27:28 CDT