Re: Problem selecting where between 1999 and 2000

From: Jim Gregory <JG200024_at_NCR.com>
Date: Wed, 16 Aug 2000 14:23:48 -0400
Message-ID: <399adc39@rpc1284.daytonoh.ncr.com>

Try:

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

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
Maverick <topgun7443_at_my-deja.com> wrote in message
news:8ned94$mf$1_at_nnrp1.deja.com...


> 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 - 13:23:48 CDT