Re: Type Conversion (Interval - Number)

On Thu, 3 Sep 1998, Ileana Soler wrote: > I have two datetime values and I need to use the difference between this > values in a mathematical formula. The difference is an interval type. But= I > can=B4t use an interval in a mathematical formula because I can=B4t conve= rt an > interval type in a numeric type. > How can I do this? Using a stored procedure -- go to DejaNews (http://www.dejanews.com) or an equivalent news archive and dig out the discussions on this subject in the last year and a half. It has been answered a number of times, and some of those times I have answered. You'll probably do better if you search on INTERVAL in the (subject) keywords and using my name rather than my login in the Author section. I'm suffering from an attack of laziness and don't want to go digging around my email archives to reproduce the answer(s) yet again. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn