hi,

I am new to Informix, i need to show list of records for given period of time.

15-03-2009 07:00 to 20-03-2009 18:00

In the table A, 2 columns (sdate: date stime: datetime HOUR to MINUTE ) for storing date and time.

i am having 3 query for this,

select * from A where sdate between('15-03-2009' and '20-03-2009') and stime between('07:00' and '18:00').


select * from A where to_date(sdate || stime) between ('15-03-2009 07:00' and '220-03-2009 18:00')

select * from A where id in (select id from A where sdate between('15-03-2009' and '20-03-2009')) and stime between('07:00' and '18:00')

Kindly provide a query if this will not work out, that would be very great full .


Thanks
Jahangeer