Re: Get sysdate as number

From: Frank van Bortel <fbortel_at_home.nl>
Date: Wed, 08 Nov 2000 22:46:24 GMT
Message-ID: <3A09A6E0.B9F83082@home.nl>

But be careful with the results: according to the Julian calendar implementation in Oracle, the year 0 exists (and is a leap year!)

Mark D Powell wrote:

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

--
Gtrz,

Frank van Bortel

Received on Wed Nov 08 2000 - 16:46:24 CST