Re: ACE Report Calculation Using DATETIME Type

Posted in 1997

Thomas Tatum — 19 Dec 1997 13:38:24 -0500 — source: Informix-list mailing list archive (1991-1998)

>>>>> "Ftwymgs" == Ftwymgs <ftwymgs@aol.com> writes: Ftwymgs> I am trying to write an ACE Report that does calculations Ftwymgs> on columns of type DATETIME YEAR TO MINUTE and I am Ftwymgs> really stuck.... Ftwymgs> What I have is two fields BEGIN_TIME and CLOSE_TIME of Ftwymgs> type DATETIME. These fields represent the time a trouble Ftwymgs> ticket was opened and closed. I want to produce a report Ftwymgs> that calculates the total number of times a ticket was Ftwymgs> closed within 15 minutes, within 4 hours and over 24 Ftwymgs> hours. Ftwymgs> I can't figure out how to calculate the difference in Ftwymgs> minutes of these two fields. Ftwymgs> Can anyone offer any help? Ftwymgs> Happy Holidays....... Ftwymgs> I cast your result to ::interval minute to minute. -- Thomas Tatum thomas@rtp.koz.com 919-489-5662 x32 919-602-6521