Re: sysdate in 2000. Irritating problem..

mwvonk_at_wxs.nl (Martin Vonk) wrote in <87d2li$2lip2$1_at_reader3.wxs.nl>:

>In the old days (<=1999) a simple query like:
>select sysdate-entrydate from members; wen't OK.
>It displayed the number of days between to date and the entrydate of a
>member.
>
>Now in 2000 it is giving idiot results. To be more specific:

i will bet that "entrydate" is not a date datatype. if it were, then you could subtract it from "sysdate" forever. if it isn't, then you must cast one or the other to the Y2K compliant date format. lesson: store dates in date datatype.
--
dave mausner Received on Thu Feb 03 2000 - 20:30:10 CST