Re: Help on querying between dates

[Christopher G Tantalo]

just a snippet of code that we would do here...
select 'X'
from dmg.history h
where
             to_date(substr(h.his_call_date,1,9),'DD-MON-RR')
                                between to_date($begin_date,'DD-MON-RR')
                                    and to_date($end_date,'DD-MON-RR');

and that works for the actual days specified, end_date and begin_date without
doing a +1 to any of the dates...
Chris
--
-------------------------------
Just Your Friendly Neighborhood
_SPIDEY_