Re: interval type

On Jun 28, 10:21am, I wrote: > } ->Can I convert some how ? > > Have a look at the extend function. You use this to change the definition of a > datetime or interval field to make it match other datetime and interval fields > to allow calculations and reformatting. Sorry Bert, I should take my own advise to others. Look before you leap. Extend only applies to datetime not to intervals. Cathy's route is probably the way to go. Perhaps Informix should include a function that coverts a datetime or interval to an integer using a specified level. Eg: timeconvert (datetime/interval expression) into seconds Jonathan? Worth putting in the request database? Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!