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

[Raul A Jager W <raul@xxxxxxxxxx>]

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