![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Sat, Aug 16 2008 6:15 AM | Permanent Link |
Heiko Knuettel | 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 |
Mon, Aug 18 2008 12:23 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Mon, Aug 18 2008 4:31 PM | Permanent Link |
Heiko Knuettel | Tim,
thanks. I already began trying things like INTERVAL '''+CAST(integer AS STRING)+'''' MINUTE ![]() Heiko |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |