datetime range query example in informix -- Posted by inturi on Saturday, June 19 2010
select * from customer where create_time between '2010-06-19 13:35:00' AND '2010-06-19 13:36:00';