kcchow@technet.sg (Chow Keng Choon) writes:
>Hi There,
>This is another DATETIME, INTERVAL type problem. I am writing an ESQL/C
>program which I want to plot a graph based on the data I capture over
>a period of time. The problem is that I need to divide an INTERVAL
>with an INTERVAL; which is a no-no. Is there a way to convert an INTERVAL
>to a number or an DATETIME seconds value.
Off the top of my head, I think this will work:
in 4GL it would be:
LET dtm_stos = EXTEND(int_stos, SECOND TO SECOND(##));
Worst case is to LET a CHAR variable = the INTERVAL,
then LET an INTERGER variable = the CHAR.
I assume something along one of these lines is possible in ESQL/C
=======================================================================
Dennis J. Pimple dennisp@informix.com Opinions expressed
Senior Consultant -------------------- are mine, and do not
Informix Software Inc Voice: 303-850-0210 necessarily reflect
Denver Colorado USA Fax: 303-779-4025 those of my employer.