Re: Get sysdate as number

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