Re: Converting between INTERVAL types

Posted in 1999

Sujit.Pal@bankofamerica.com — Thu, 12 Aug 1999 10:11:03 -0700 — source: Informix-list mailing list archive (1991-1998)

Arnar Which version of database are you using? Does not work for me - I am using 7.30.UC8. HTH Sujit Arnar Birgisson <arnar@visir.is> on 08/12/99 04:31:26 AM To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Re: Converting between INTERVAL types Try the following: select ('1 02:31'::interval day to minute)::interval hour to minute from systables where tabid = 1 in a normal query: select intervalfield::interval day to minute from table where ... It worked fine with me.. Arnar ----- Original Message ----- From: Christian Allaire <callaire@ergonet.com> To: <informix-list@iiug.org> Sent: Wednesday, August 11, 1999 9:13 PM Subject: Converting between INTERVAL types > 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 > >