Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: epoch time

Re: epoch time

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 15 Nov 2006 04:48:29 -0800
Message-ID: <1163594909.640103.317180@b28g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US