Re: Converting between INTERVAL types

If you are speaking with reference to a datetime column ( datetime ,day to minute), you can use the following SELECT statement to retrieve the date in 'hour to minute' format select EXTEND (<column_name, format 'day to minute'>, hour to minute) from <table_name> Hope this is what you were looking for. George ----- Original Message ----- From: Christian Allaire <callaire@ergonet.com> To: <informix-list@iiug.org> Sent: Thursday, August 12, 1999 2:43 AM 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 >