On Sat, 22 Jan 2000 18:07:40 GMT, attwoody <attwoody_at_my-deja.com>
wrote:
>
> What I _wanted_ was to purge all the records earlier than
> July 3, 1999; what happened was that EVERYTHING was deleted
> because '13-JAN-00' was interpreted as being less than
> '03-JUL-99'; ie, as a date in 1900 and not 2000.
>
> When I executed a similar query in 1999, everything was
> just fine.
>
My understanding of what has happened here is slightly different than
yours. I think 13-JAN-00 was correctly interpreted as being year
2000. As it was a date on the database the century would be known
anyway. However when you input 03-JUL-99 as no century was specified
the current century was assumed so your delete got rid of anything
dated before 03-JUL-2099. I know it's only a subtle difference but it
may be important to know that it is your parameter that was
misinterpreted and not the dates on the database.
Received on Sun Jan 23 2000 - 02:41:00 CST
