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!

TO_DATE Function Is not working

540831Jan 31 2007 — edited Jan 31 2007

Hi Friends,

select * from view_date where to_date(my_date) between '01-dec-06' and '31-dec-06';

This query is not responding...

I have the the date field in character in the view so i need to convert it to date ,so that iam using to_date function and its not responding.

Without using to_date iam getting the results but not the exact results,it includes all the record sets.

Help me in this

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 28 2007

Added on Jan 31 2007

12 comments

2,964 views