Re: Date/Time Calculations in ACE

Posted in 1994

Danni Bauer — 23 Sep 1994 17:38:10 GMT — source: Informix-list mailing list archive (1991-1998)

Greg Wake (greg@gsesco.DIALix.oz.au) wrote: > Is it possible to Date/Time calculations within the ACE report > writer for ISQL V4.10???? > I am desperately trying to write a report that adds up the time > spent on a particular activity and I don't seem to be able to > do it unless in the my table I split the time up into 3 different > fields, namely hours, minutes and seconds. > Any thoughts??? Anyone??? If both fields are DATETIMEs, then the difference can be measured in an INTERVAL. -- o-o Danni Bauer | \\ o | O oo o-o o-o bauer@gtetel.com | / | | | | | | | o-o o-o-o o o o | 73764.63@compuserve.com