Another DATETIME, INTERVAL type problem

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. Have anyone done this before or have a good solution, please share! Thanks in advance. - Ken Chow kcchow@technet.sg