URGENT Help Needed : DateDiff Function in informix

Posted in 1999

Jie — Mon, 30 Aug 1999 23:48:52 -0400 — source: Informix-list mailing list archive (1991-1998)

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

↪ replying to Jie

Mike Aubury — Tue, 31 Aug 1999 18:15:52 +0000 — source: Informix-list mailing list archive (1991-1998)

On Tue, 31 Aug 1999, Jie wrote: >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 Just subtract one from the other to get the number of days (if they are dates) : select date_later-date_earlier from ...