var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to search by Date in Informix SQL?
How do I search by a specific date in Informix? I tried the following, but I'm missing something.
Fieldname: resultdate is (datetime)
WHERE resultdate = DATE('2010-10-08')
WHERE To_CHAR(resultdate,'YYYY-MM-DD') = '2010-10-08'
Last edited by mlong30; 11-16-10 at 13:06.
You only have to write:
SELECT * FROM vtest WHERE resultdate = "2010-10-08";