Re: Converting sysdate to "Seconds since 1970"

Here's a package from Steve Baldwin <steven.baldwin_at_hancorp.com.au>

CREATE OR REPLACE PACKAGE PKG_UnixDate AS  FUNCTION To_DateU (i_date IN DATE) RETURN PLS_INTEGER ;   PRAGMA RESTRICT_REFERENCES (To_DateU, WNDS, RNDS) ;  FUNCTION From_DateU (i_Udate IN PLS_INTEGER) RETURN DATE ;   PRAGMA RESTRICT_REFERENCES (From_DateU, WNDS, RNDS) ; END pkg_UnixDate ;
/
CREATE OR REPLACE PACKAGE BODY pkg_UnixDate AS

    k_BaseDate CONSTANT DATE := to_date('01011970','DDMMYYYY');  k_SecsPerDay CONSTANT PLS_INTEGER := 86400;  k_BaseDate_J CONSTANT PLS_INTEGER := to_char(k_BaseDate, 'J'); --
FUNCTION To_DateU (i_date IN DATE) RETURN PLS_INTEGER IS BEGIN
 RETURN ((to_char(i_date,'J') - k_BaseDate_J) * k_SecsPerDay) + to_char(i_date,'SSSSS');
END ;
--
FUNCTION From_DateU (i_Udate IN PLS_INTEGER) RETURN DATE IS BEGIN
 RETURN k_BaseDate + (i_Udate / k_SecsPerDay); END ;
END PKG_UnixDate ;
/

--
Have a nice day
Michel

Jonathan Gauthier <jonathan.gauthier_at_cgi.ca> a écrit dans le message : 9Ha14.375$Zc3.272_at_198.235.216.4...
> Hi,
>
> I'm looking for a SQL statement or PL/SQL code to convert the Oracle sysdate
> into the number of seconds since 1970. Anyone could forward this to me
> please?
>
>
>
Received on Wed Dec 01 1999 - 09:37:41 CST