Re: q: Adding a interval to a datetime in a SELECT statement?

Hi Jack, you may try the statement "select EXTEND(start_time,YEAR TO FRACTION) + air_duration from inf528899_r". Cheers, Jozsef Jack Deserno wrote: > Hi all, > > My table has among others following columns: > > start_time datetime year to second, > air_duration interval second(9) to fraction(1) > > and I want to calculate within a select statement the end_time is the > possible ? > > I tried following statement: > > isql hostr1 <<! > select start_time + air_duration from inf528899_r > ! > > and got this message: > > 1266: Intervals or datetimes are incompatible for the operation. > Error in line 1> Near character position 49 > > TIA, > Jack Deserno