I have a simple grid for a table that has a date in it. When I do a search for date, the generated SQL does an "EXTEND(p_date, YEAR TO FRACTION) = '2012-08-12'" when searching for 08/12/2012. Is there anyway to tell the system to not do the Extend? The field is just a date, not date/time. SQL type is date in the fields screen. I am using the native Informix driver.
No announcement yet.
Search date generated SQL