I have a similar issue but what i wish to do is select records where date is greater than or equal to one specific date .
When I build a query the query the column tool converts the date to yyyy-mm-dd hh:mm:ss
e.g.Select OPDATE >= date '2007-03-25 00:00:00' the thing is it drops a bunch of records that it should pick up greater than this date.
I wonder if it has anything to do with American vs European date formats or how the record was keyed into the database. As all dates normally look like 25/03/2007 when viewed in the table i.e. dd/mm/yyyy as per:
So how do I ensure I get the correct records without missing any ,if you can imagine I have over 15000 records spanning 13 years I don't want to write a query for each and every potential date value).
eg OPDATE IN (date '2007-03-25 00:00:00' ,date '2007-03-26 00:00:00' ,date '2007-03-2700:00:00' ,date '2007-03-28 00:00:00' ,date '2007-03-29 00:00:00' .....)
( which equates to 4749 potential date results or 365.25 days a year for 13 years )