Converting between INTERVAL types

Posted in 1999

Christian Allaire — Wed, 11 Aug 1999 17:13:58 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi, I would like to know if it is possible to convert a type "interval day to minute" to an "interval hour to minute", and is so how do you do it ? For example, 1 02:31 would become 26:31 Thanks, Chris

↪ replying to Christian Allaire

Paul Roberts — 11 Aug 1999 21:27:25 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7osp79$lu0$1@news.interlink.net>, Christian Allaire <callaire@ergonet.com> wrote: >Hi, > >I would like to know if it is possible to convert >a type "interval day to minute" to an "interval hour to minute", >and is so how do you do it ? > >For example, 1 02:31 would become 26:31 > >Thanks, > >Chris In I-4GL it is automatic: | main | | define dm interval day to minute | define hm interval hour to minute | | let dm = " 1 02:31" | | let hm = dm | | display "dm = ", dm | display "hm = ", hm | | end main gives you: | dm = 1 02:31 | hm = 26:31 - Paul