Re: Sample SQL needed for DateDiff(minutes, Date1, date2)

Posted in 1997

Kenneth Xu — Tue, 30 Dec 1997 22:59:27 +0800 — source: Informix-list mailing list archive (1991-1998)

define m as interval minute to minute m=datetime1 - datetime2 Holp helps Ken. scummings@idesign.com wrote in message <883424476.1040515073@dejanews.com>... >For example, if datetime1 = 1/1/1997 11:10:05 and datetime2 = 1/1/1997 >12:30:45 then the result I'm looking for is 80 minutes and not: 0 01:20