Re: Another DATETIME, INTERVAL type problem

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.