Re: Rounding to nearest one sixteenth of an inch. (Solved)

2004-01-12 Thread Richard Davies
On Monday 12 Jan 2004 22:23, you wrote: > Richard Davies wrote: > > Does anyone have any ideas on how to round a number in the form > > float(3,4) to the nearest sixteenth of an inch. > > Multiply by 16, round, divide by 16. Obvious really, update table1 set field1 = (round

Re: Rounding to nearest one sixteenth of an inch.

2004-01-12 Thread Dan Nelson
In the last episode (Jan 12), Richard Davies said: > Does anyone have any ideas on how to round a number in the form > float(3,4) to the nearest sixteenth of an inch. > > eg ending in > .0625, > .125 > .1875 > .25 > .3125 ROUND(myfield*16)/16 should work. -- Dan Nelson [EMAIL

Rounding to nearest one sixteenth of an inch.

2004-01-12 Thread Richard Davies
Does anyone have any ideas on how to round a number in the form float(3,4) to the nearest sixteenth of an inch. eg ending in .0625, .125 .1875 .25 .3125 etc I haven't found anything in the manual about this, maybe normal people don't want to do this. -- Regards Richard -- MySQL General