Re: ORACLE DATE IN WHERE CLAUSE PROBLEMS

From: Ian Bainbridge <bainbridge_i_at_perc03_at_bgers.co.uk>
Date: 1995/06/28
Message-ID: <3sr1iq$au_at_atlas.bgers.co.uk>#1/1


 Davor,

 A few observations.

 Your first select returns 20 rows but your are doing   < 26 june thereby excluding the entries for 26 june. Try this  as < 27 june and see if you get 25 rows as per the between.

 As to the strange counts, have you checked the dates to see the acutal  *century* in these dates ? How are these dates being input ? Are they  perhaps entered via forms with an 11 character date field but the user just  enters 21-JAN-95. If memory serves me correctly this will insert a date of  21-JAN-0095 !   Hope this helps.

-- 
+--------------------------+-------------------------+-----------------------+

| Ian Bainbridge | bainbridge.i_at_bgers.co.uk|Phone: (44)191-216-0202|
| British Gas ERS | Newcastle Upon Tyne, UK | x2790 |
+--------------------------+-------------------------+-----------------------+
Received on Wed Jun 28 1995 - 00:00:00 CEST

Original text of this message