Re: Another Datetime/Interval question

On Mon, 2005-12-19 at 06:12, Richard Spitz wrote: > And on to the next INTERVAL problem. We are still in IDS 7.31, so > no casts. > > I have a table where the duration of a procedure (in minutes) is > stored in a smallint column. Another table stores beginning and end > of a procedure in "datetime year to minute" columns. > > I found no way to compare durations between these tables. Subtracting > end from beginning in the second table yields an interval, which I > can "convert" into the duration in minutes with Jonathan's trick. > But there seems to be no way to convert or compare smallint to interval. > > I tried "SELECT INTERVAL(<column>) MINUTE(4) TO MINUTE FROM <table>" > but that gives me a syntax error. SELECT <column> UNITS MINUTE FROM <table> HTH, Carsten. sending to informix-list