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