RE: SQL user function to turn a decimal number to a fraction

<<who else but butchers, bakers, and candlestick makers use fractions? >>

Carpenters come to mind. And auto mechanics. And people who run marathons.

Paul Nelson
Cell 708-670-6978
Office 409-267-4027
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Booth
Martin
Sent: Thursday, December 22, 2016 12:04 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL user function to turn a decimal number to a fraction

What you say is true. I don't dispute that. On the other hand, the OP
is working to solve a business problem - who else but butchers,
bakers, and candlestick makers use fractions? Providing a solution that
will give "4/13ths" as an answer has no useful purpose so far as I can see.


On 12/22/2016 6:25 AM, Raul A Jager W wrote:

The question is about converting decimal to fraction. Every decimal
can be represented with a finite fraction, but some fractions require
an infinite decimal representation. Like 1/3 that sometimes it is
represented as 0.333... to indicate that the number has been
truncated. For the decimals that are truncated, to convert to
fraction divide by 999... same number of 9 as required to repeat the
cycle. For example 1/7 is 0.142857142857... 1/7 =
142857/999999 0.333... = 3/9 = 1/3 also 333/999 = 1/3

____________________________________________________________________________
___________________

On 12/21/2016 10:45 PM, Booth Martin wrote:

1/3 is not a tool size. .333333333/.03125 = 11 which becomes 11/32
or 5/16, depending on rounding rules.

I suppose this becomes a design decision where application and
expectations delineate a final choice.


On 12/21/2016 2:47 PM, Rob Berendt wrote:

Booth,
What about 1/3?

Personally I might consider basing this on a table.


Rob Berendt

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color
-- -- Verificado por Anti-Virus Corporativo Symantec --