Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: command to display time in DATE format
<mehaboob_at_gmail.com> wrote in message
news:1149603061.349299.173000_at_c74g2000cwc.googlegroups.com...
> 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
>
Why store numbers in character fields? Store numbers in number fields. (myfield/(24*60*60))+to_date('01/01/1970','mm/dd/yyyy'), Jim Received on Tue Jun 06 2006 - 09:28:43 CDT