Dates and Oracle

We have several client server applications connecting to Oracle 7.3 and have just discovered some problems with dates.

One application inserts sysdate into a table insert into table1 (the_date) values (sysdate)

Another apllication selects data from this table and does some further processing and this is where the problem arises
select * from table1 where the_date =
to_char('01-07-1998','dd-mm-yyyy')

This returns no rows although if we do a select the_date from table1 we see that there is one record with date 01-JUL-97.

It appears that SYSDATE inserts the current time into the column as well and hence the problem when trying to select data.

Any ideas on how to overcome this or how to deal with dates in oracle

Thanks

Linda Received on Wed Jul 01 1998 - 05:08:38 CDT