Hi all,
I am trying to optimize the queries in my application. Is there a performance difference between (to_char(myDate ,format) < myString) and (myDate < to_date(myStrin g, format)).

ex. Select * from myTable where (to_char(fieldD ate, 'MM/DD/YYY') <= queryDate )

or Select * from myTable where (fieldDate <= to_date(queryDa te, 'MM/DD/YYYY') )

assuming fieldDate is a date or...