Re: Convert Date to Number

u can write a function to do that
or just use a simple query like

select sysdate-to_date('01/01/1970 00:00:00','dd/mm/yyyy')*24*60*60 from dual

On Thu, 10 Apr 2003 16:39:22 GMT, "David COSTE" <dco_at_compaq.com> wrote:

>Hello all,
>
>Does someone know if there is a simple way to convert dates in number with
>Oracle 9.2.0.
>For example, how to convert a date in a number of seconds elapsed since
>1/1/1970 at 0:00:00 ?
>
>Thanks in advance
>David
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Apr 10 2003 - 12:41:48 CDT