How to format an interval data type?
Posted in 1998
Sujit.Pal@alltel.com — — source: Informix-list mailing list archive (1991-1998)
Hello All Maybe this is really simple, but I have RTFM'd and am still not any wiser. I have a DATETIME column (call it event_since) that captures cumulative point in time statistics in another column in the same table (call it cum_num_events). So I have this query: SELECT (CURRENT - event_since)/cum_num_events events_per_minute FROM event_tracker_table WHERE <condition>; My problem is that (CURRENT - event_since) comes out like 17 03:13:45.000 which is 17 days 3 hours 13 minutes 45.000 seconds. I want to get this in minutes. Is there a way? Thanks Sujit Pal