RE: URGENT Help Needed : DateDiff Function in informix

Posted in 1999

William Raper — Tue, 31 Aug 1999 15:49:49 -0400 — source: Informix-list mailing list archive (1991-1998)

Informix will compute the difference through standard mathematical operations. You may want to DECLARE the receiving field as INTERVAL data type for presentation. HTH Bill Raper Senior Database Administrator Catalina Marketing 727-579-5134 Pager 727-529-8331 williamr@catmktg.com > -----Original Message----- > From: Jie [SMTP:Jie.Gao@Tequilasoftware.com] > Sent: Monday, August 30, 1999 11:49 PM > To: informix-list@iiug.org > Subject: URGENT Help Needed : DateDiff Function in informix > > I am converting SQL Server codes to Informix. In SQL Server, I used > DateDiff > function to calculate the time difference between two date fields. I do > not > know what is the equivalent function in Informix. Please help! > Thanks in advance >