How do I search by a specific date in Informix? I tried the following, but I'm missing something.

Fieldname: resultdate is (datetime)

SELECT *
FROM vtest
WHERE resultdate = DATE('2010-10-08')

SELECT *
FROM vtest
WHERE To_CHAR(resultdate,'YYYY-MM-DD') = '2010-10-08'

Thanks.
Matt

Hi mlong30,

You only have to write:

SELECT * FROM vtest WHERE resultdate = "2010-10-08";

Have fun!