Re: somebody know how substract an interval with an integer

Marco Silva wrote: > > Hi: > my problem is substract to datetimes datatype year to minute of an integer, > in a select statement > i dont know how convert that integer in a interval, for solve this problem You do not state where you need to do this: ESQL/C, 4GL, SPL, pure SQL? Where here goes nothing anyway, a generic answer. OK assume the integer contains the number of minutes equivalent to one day that you want to subtract in SQL: SELECT dtime_col - interval(1440) minute(4) to minute. Art S. Kagel