SQL Language (MOSC)

MOSC Banner

What AM I Missing Using Between Statement With Dates

edited Feb 18, 2010 5:27AM in SQL Language (MOSC) 18 commentsAnswered ✓
 Hi Folks

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'));

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center