Re: Get sysdate as number

From: Mark D Powell <markp7832_at_my-deja.com>
Date: Wed, 08 Nov 2000 14:00:05 GMT
Message-ID: <8ubm92$hvt$1@nnrp1.deja.com>

In article <3A09514E.1AD83BDE_at_capgemini.nl>,   Patrick Diks <patrick.diks_at_capgemini.nl> wrote:
> 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.

Patrick gave the response that I think Klaus can use, but since did not specifiy what type of number or what he wanted it for he may want the Oracle Julian date which you can get using:

UT1> l
  1* select to_char(sysdate,'J') "Julian" from sys.dual UT1> /

Julian

---

2451857

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Wed Nov 08 2000 - 08:00:05 CST