Re: Time format Unix
From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Tue, 11 Mar 2003 15:10:14 GMT
Message-ID: <q%mba.43243$3D1.1625_at_sccrnsc01>
Date: Tue, 11 Mar 2003 15:10:14 GMT
Message-ID: <q%mba.43243$3D1.1625_at_sccrnsc01>
Already answered in your other post
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "kderaedt" <kderaedt_at_hotmail.com> wrote in message news:3e6dd1ec$0$83872$ba620e4c_at_news.skynet.be...Received on Tue Mar 11 2003 - 16:10:14 CET
> Hi,
>
> I have a problem with some time / date fields in a table. I'm using a
> Oracle database on a Solaris system. Some field in that table are time
> fields. This is an example of a field.
> 1046170886 this is represented as number of seconds from 00:00:00: UTC,
Jan
> 1, 1970.
> How can I reformat this to a more logical date in a select statement?
>
> Regards
>
> Karel
>
>
>