how to do diff for 2 date value in informix?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vchu - 24 Jun 2008 00:28 GMT

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?

Reply to this Message

Jonathan Leffler - 24 Jun 2008 06:45 GMT

> I am trying to subtract a datetime field with now(current), and like to see
> something like
[quoted text clipped - 3 lines]
> 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.

Signature

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

Reply to this Message