Re: ORACLE DATE IN WHERE CLAUSE PROBLEMS

Davor,

There are some differences:
* between ... and ... is a inclusive comparison, and can equivalently   written as date_kol >= '01-jan-95' and date_kol <= '26-jun-95' * Note that Oracle has a time part in the date-column: if your column   has been filled using SYSDATE, you better add the time part, as in:   date_kol <= '26-jun-95' + (60*60*24 - 1) / (60*60*24)   (or, more simpel: date_kol < '26-jun-95' + 1)

Hope this explains.

Kind regards,

Herman de Boer
Senior consultant
Oracle Netherlands

--> These are PRIVATE opinions, NOT Oracle one's <--
Received on Wed Jun 28 1995 - 00:00:00 CEST