Re: Comparing Dates

>>Why does the following occur?
>>
>>SQL> r
>> 1 select * from brit_attr_value where TO_DATE(attr_value) between
>> 2* sysdate and sysdate+7;
>>ERROR:
>>>> SOME DELETED <<<<
>Y
>-------------------------
>10-AUG-95
>
>it works without to_date also.
>Swapan

        Ah! Stupid me! :) I figured it out. I need to add another clause like "and attr_num = 5", because not all the attr_values are dates. They vary depending on the attribute number. (ie: attr_num=1 may be the description)

        Thanks for the reply!

        Brit Willoughby
	Brit.Willoughby_at_WichitaKS.ATTGIS.Com