hi
Actually the field in the oracle is date.
This is the way i am writing select * from faults where to_char(to_date(occured,'dd-mon-yy'),'dd-mon-yyyy')=to_char(to_date('"&date1&"','dd-mon-yy'),'dd-mon-yyyy')
This is working finein my office pc and not working in my home PC.The date...