Re: Time Stamp calculations

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Mon, 04 Feb 2002 20:28:14 GMT
Message-ID: <3C5EEEDE.5BB5D100@ci.seattle.wa.us>

There may be another way, probably is in Oracle. But why not subtract 01-JAN-1970 from SYSDATE and then multiply your way to seconds.

Daniel Morgan

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
Received on Mon Feb 04 2002 - 14:28:14 CST