Re: INTERVAL HOUR TO SECOND TO INTEGER
Thomas J. Girsch wrote:
> I know a similar question came up recently, but does anyone have
> any idea how to convert an INTERVAL HOUR TO SECOND to INTEGER?
> Based on my application's design, I can't resort to ESQL.
Don't you have access to DejaNews? It will allow you to poke around
the recent history.
When you said INTEGER, did you mean integer hours, minutes or seconds?
I'm assuming you meant seconds. You use a stored procedure like I've
shown in several examples in the last month:
-- Untested code. The variable s is necessary; so is d.
CREATE PROCEDURE ivhs_secs(i INTERVAL HOUR TO SECOND) RETURNING INTEGER; DEFINE s CHAR(10);
DEFINE s INTERVAL SECOND(9) TO SECOND;
LET d = i;
LET s = d;
RETURN s;
END PROCEDURE;
EXECUTE PROCEDURE ivhs_secs(INTERVAL(-98:34:21) HOUR TO SECOND);
SELECT ivhs_secs(ivhs_col) AS seconds ...
FROM ...
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN
#include <disclaimer.h>