Re: Comparing dates

Glenn Baron wrote:
>
> My guess would be that EVENTDATE is actually 01-MAY-0099 ...
> try :
>
> select to_char(eventdate,'dd-mon-yyyy') from history ;
>
> to expand it including century.
> You might have some Y2K bugs to fix ...

Thanks a lot, you gave me the right hint to find the problem. The date was stored as 01-may-3899 :)

Well, I felt into an ugly trap: the date was generated in Java and stored through JDBC. The constructor for java.sql.Date expects the expression year-1900 as input...

bye
--
Sam Jordan Received on Mon May 03 1999 - 05:41:07 CDT