Re: Get sysdate as number

Hi,

You need a reference date to count from ie: SQL> select sysdate - to_date('01-01-1970','dd-mm-yyyy') from dual;

SYSDATE-TO_DATE('01-01-1970','DD-MM-YYYY')

                                 11269,588

The resulting number is the difference in days.

HTH, Patrick Diks

klausspeierl_at_my-deja.com wrote:
>
> I want to get the absoulute oracle time sysdate as a number.
> I tried
> select to_number(sysdate) from dual
>
> But I always got a error.
>
> Any ideas?
>
> Thanks in advance
>
> Klaus
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 08 2000 - 07:12:46 CST