Re: Get sysdate as number

From: Van Messner <vmessner_at_bestweb.net>
Date: Thu, 09 Nov 2000 01:33:51 GMT
Message-ID: <3anO5.81$s83.8456@monger.newsread.com>

Am I missing something? If you started counting in BC and moved forward to AD there should be a year zero, shouldn't there?

Van

"Anton Dischner" <dischner_at_klch.med.uni-muenchen.de> wrote in message news:081120001504586067%dischner_at_klch.med.uni-muenchen.de...
> Hi Klaus,
>
> what you are looking for is the Julian calendar, started Dec 31, 4713 BC.
>
> Try select to_char(sysdate, 'J') from dual;
>
> regards,
>
> Toni
>
> > I want to get the absoulute oracle time sysdate as a number.
>
> --
> ZXR750H, 55 Mm.
> Q: How did the medical community come up with the term "PMS"?
> A: "Mad Cow Disease" was already taken.
> Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
Received on Wed Nov 08 2000 - 19:33:51 CST