Rounding numbers
Posted in 1993
Francis Fang — — source: Informix-list mailing list archive (1991-1998)
I currently need to pull in a bunch of floating numbers and they are stored in the Informix database as 7 decimal place numbers. I then pull them into a 4th Dimension database where the accounting staff manipulates the data. They however want to have the numbers round to 2 decimal places. While I can do this in 4D, it is very slow and so I was wondering if this was something I could incorporate into my isql query. I've looked through the index of my Informix manual but haven't really found anything. Thanks in advance. Frank.