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 --