Re: Rounding numbers

Posted in 1993

Alan Popiel — Mon, 8 Feb 93 09:27:30 MST — source: Informix-list mailing list archive (1991-1998)

Bob Baskett writes: ->From: inf_bb@hermes1.sps.mot.com (informix users bb) ->Date: Mon, 8 Feb 93 08:23:30 MST ->To: ffang@grover.printing.uiowa.edu, informix-list@rmy.emory.edu ->Subject: Re: Rounding numbers -> ->select order_num, ROUND(total_price,2) ->from items ->where ROUND(total_price,2) = 125.25; -> ->this is almost straight out of the isql reference manual, pg. 7-374. Bob, What version of Informix are you using. This useful looking function does not appear to be in version 4.00, at least not in my reference manual. Regards, Alan +------------------------------+---------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Martin Marietta, LSC | ( Please note: My opinions do not ) | | P.O. Box 179, M/S 5422 | ( represent official Martin policy. ) | | Denver, Colorado 80201-0179 | Voice: 303-977-9998 | +------------------------------+---------------------------------------+