Re: Converting INTERVAL to integer minutes?

You could try looking up EXTEND in the manuals. It should be in the syntax guide under "expression." David C Mudie wrote in message ... > >Hi, I'm new to Informix and to this newsgroup. I am using Informix >Developer's Edition v7.20.UC4 on Solaris 2.6. I have a field of >type INTERVAL DAY TO MINUTE and I would like to convert it to >an integer count of minutes. Is there some built-in conversion >function I can use for this, or do I have to write my own stored procedure >or host-language routine? > >I haven't been able to find any answers in the Informix docs or FAQ, >and my version of "dbaccess" doesn't seem to recognize the CAST >operator defined in SQL-92. Any pointers appreciated, thanks! > >David > >-- >XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XX >David C Mudie UCB Microlab mudie@microlab.eecs.berkeley.edu > Berkeley CA 94720 http://www-microlab.eecs.berkeley.edu >XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XX