Hi,

I don't get it how to typecast an integer to an interval. I want to achieve something like
this :

FUNCTION INCHOUR(IN ts TIMESTAMP, IN h FLOAT)
RETURNS TIMESTAMP
BEGIN
  RETURN ts + CAST(CAST(h*60 AS INTEGER) AS INTERVAL MINUTE) ;
END;


Thanks in advance,

Heiko

Heiko,

<< I don't get it how to typecast an integer to an interval. I want to
achieve something like this :

It's a bug in the casting of integers to intervals.   A fix will be
available shortly.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

thanks. I already began trying things like INTERVAL '''+CAST(integer AS STRING)+''''
MINUTE    

Heiko