Mr.davey23uk,

I'm new to DBA,i'm in learning process,i just copied & pasted the work i did in SQL* Plus & you know my mistake i gave the query as April 15th,2006 only & it gave the result exactly what i posted.

ok.. anyway after seeing your reply,i found my mistake & corrected it,issued the query with the date March 15,2006.This time also,i'm getting the same problem and i made it clear to you.

As a Senior member,you found the mistake i made & i corrected it next time,now it's your responsibility to give the proper answer,but it's not the way to behave,if you're really interested and able to help me,do so,otherwise don't send rubbish replies..

Good bye...