Re: ORACLE DATE IN WHERE CLAUSE PROBLEMS

In article <3ssco6$jq_at_nlsu110.nl.oracle.com> hboer_at_nl.oracle.com (Herman de Boer) writes:
#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

You could also truncate the date, i.e. trunc(date_kol) between '01-jan-95' and '26-jun-95'

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