Re: command to display time in DATE format

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Tue, 06 Jun 2006 16:16:47 GMT
Message-ID: <4485a999.1011390@news.hetnet.nl>

On 6 Jun 2006 07:11:01 -0700, mehaboob_at_gmail.com wrote:

>Hi,
>
>In oracle DB table,I have a varchar field which stores time in EPOCH
>fomat
>for eg:11652232 secs
>
>Is there a command to display the above time in Date format? (something
>like DD MM YY)
>
>Mehaboob
>

If EPOCH format is the number of seconds since 1 Jan 1970:

to_char(to_date('19700101', 'yyyymmdd') + EPOCH_FIELD/86400,'dd mm yy')

Jaap. Received on Tue Jun 06 2006 - 11:16:47 CDT