Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: epoch time
Lakshmi wrote:
> Hi
>
> Can date be stored and retrived as unix epoch time in database?
>
> Thanks
> Lakshmi
declare
x TIMESTAMP WITH TIME ZONE;
begin
x := TO_TIMESTAMP_TZ('1970-01-01 00:00:00 +00:00', 'YYYY-MM-DD
HH24:MI:SS TZH:TZM');
end;
Received on Wed Nov 15 2006 - 06:48:29 CST