Problem selecting where between 1999 and 2000

I am trying to select data using the following where clause:

where to_char(start_ts,'MM/DD/YYYY') between '12/19/1999' and '08/15/2000'

start_ts is defined as DATE.

There is data that should be selected. The where clause works when using between '01/01/2000/ and '08/15/2000', but also fails when using between '12/31/1999' and '08/15/2000'.

Is this a known bug? This is Oracle version 8.0.5 running on AIX 4.2.1.

Your help is appreciated.
- Tom

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 16 2000 - 10:51:10 CDT