What AM I Missing Using Between Statement With Dates
I cannot figure out why I am not getting all my data when using the BETWEEN statement with a date in one particular sql and not the other
Can anyone see what i am missing
Any assistance will greatly relieve my stress :-)
Thanks
Jim
**************************************************
create table date1
(
col_date date
);
insert into date1 values (to_date('2009/01/01','yyyy/mm/dd'));
insert into date1 values (to_date('2009/02/01','yyyy/mm/dd'));
insert into date1 values (to_date('2009/03/01','yyyy/mm/dd'));
insert into date1 values (to_date('2009/04/01','yyyy/mm/dd'));
insert into date1 values (to_date('2009/05/01','yyyy/mm/dd'));