Re: Time Stamp calculations

From: S.Llabres <sllabres_at_baden-online.de>
Date: Mon, 04 Feb 2002 18:32:45 +0100
Message-ID: <3C5EC5BD.A2DE18E7@baden-online.de>

Joshua Goodstein wrote:

> I am trying to create a procedure that changes the sysdate in Oracle
> to the UNIX time to store in a field. aka i execute the
> function/proocedure and it will insert the seconds since Jan 1 1970 in
> the feild. IS there a procedure that does this already? Thanks in
> advance
>
> I want sysdate to unix date, not unix date to sysdate.
>
> thanks in advance
>
> J

Are you searching for something like:

select trunc(sysdate-to_date('19700101','YYYYMMDD')) from dual;

Bye, Stefan... . . Received on Mon Feb 04 2002 - 11:32:45 CST