Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Between operator not working with varchar2 column values...

user1680623Jun 19 2014 — edited Jun 20 2014

I having table TR_DATE which following date like APR01 to MAR31 total 366 rows

VDATE
APR01
APR02
APR03
APR04
APR05
APR06
APR07
APR08
APR09
APR10
APR11
APR12

when i am searching the data in this table through below query not getting any data please help in this regards...

SELECT * FROM TR_DATE WHERE UPPER(VDATE) BETWEEN UPPER('may01') AND UPPER('aug10');

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2014
Added on Jun 19 2014
18 comments
2,593 views