Re: Converting sysdate to "Seconds since 1970"

A copy of this was sent to "Jonathan Gauthier" <jonathan.gauthier_at_cgi.ca> (if that email address didn't require changing) On Wed, 01 Dec 1999 14:57:09 GMT, you wrote:

>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?
>
>

see the website in my signature, specifically http://osi.oracle.com/~tkyte/Misc/CTime.html

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Dec 01 1999 - 09:20:22 CST