var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: To_Date function
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 .