I have a problem with the oracle date comparison --plz help

From: <jambesh_at_gmail.com>
Date: 20 Sep 2005 14:02:07 -0700
Message-ID: <1127250126.992203.86470@g49g2000cwa.googlegroups.com>

Hi , every body

I have written a query

• QUERY------------------------------ select count(*) from newtable where order_tm > TO_DATE('19-SEP-05' , 'dd-mon-yy') and order_tm < to_date('21-SEP-05','dd-mon-yy') and status='APPROVE'

  ---

--------------------RESULT--------------------------------

this give me a result of 50

---

when i remove count(*) to see all field and put * over ther i can see ...this query select the order from 19th sep also which it should not as i have given a greater then symbol on that condition.

can you please explain me why it is happening so..??

is this query be substitute as approve_tm = '20-SEP-05' and status='APPROVE' what is wrong with this query ??? it doesn't give currect result. Received on Tue Sep 20 2005 - 16:02:07 CDT