how to do diff for 2 date value in informix?

Hi All, I am trying to subtract a datetime field with now(current), and like to see something like i.e. 6.56 days round((interval(0) minute(9) to minute + (extend(current, year to minute) - t.last_reported_dt))/60/24,2) as inmins, can u help pls? -- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/informix/200806/1

vchu via DBMonster.com wrote: > I am trying to subtract a datetime field with now(current), and like to see > something like > > i.e. 6.56 days > > > round((interval(0) minute(9) to minute + (extend(current, year to minute) - > t.last_reported_dt))/60/24,2) as inmins, This was discussed in this news group just last week. Try looking for iv_seconds with Google. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/ publictimestamp.org/ptb/PTB-3565 tiger 2008-06-24 03:00:05 506A57E325A796CE9818DFAC32C0D9710B45F5FA3595D63F