Re: Subtract Hours From A Given Date

> > Wait a minute. I had to run home and get my old high school text book out :)
> >
> > 10/1440 is rational
> > AND SO IS 0.006944444444444........ (lots of 4's)
> >
> > (and so is 5/24) -- in fact every number that can be represented as X/Y is
> > rational. 10/1440 is a repeating number but it is not irrational.
> >
> > Not that is matters.....
> >
> > [snip]
> >
> > --
> > See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> > Current article is "Part I of V, Autonomous Transactions" updated June 21'st
> >
> > Thomas Kyte tkyte_at_us.oracle.com
> > Oracle Service Industries Reston, VA USA
> >
> > Opinions are mine and do not necessarily reflect those of Oracle Corporation
>
> I would believe you if you could be given the number of 0.2083333333333 and work
> backwards to determine that it is the ratio of 5/24 - I suspect that isn't possible.

0.20833333333333(etc.)

• 0.208 + 0.000333333333(etc.)

0.000333333333(etc.) = (1/3)/1000 = 1/3000

0.208                = 208/1000 = 624/3000

so 1/3000 + 624/3000 = 625/3000

Now divide the top and bottom by 125 and you get 5/24.

That was easy for me and I haven't even studied maths for 10 years.

Ian. Received on Mon Sep 13 1999 - 10:15:23 CDT