×

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.



  1.  Home
  2. RPG400-L
  3. February 2020

Re: [EXTERNAL] Re: What is a good way to round up numbers in free form?

On Wed, Feb 12, 2020 at 1:39 PM Alan Shore via RPG400-L
<rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Justin replied earlier - and suggested using the SQL command CEILING

Well, if you are rounding specifically to zero decimal places, toward
positive infinity, then sure. Correspondingly, you can get *some* of
the rounding functionality with FLOOR and TRUNCATE.

But rounding to arbitrary decimal places, or niche modes like
half-down or away-from-zero, require you to compose your own (not too
hard, given the available building blocks), or set the rounding mode
and use QUANTIZE.

John Y.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.