Re: Insert decimals with rounding

2005-07-20 Thread Michael Stassen
sean c peters wrote: Hi all. I am trying to figure out if there is a way to configure MySQL so that when inserts occur on decimal fields where the value being inserted has more precision than the field specification, then the value inserted is rounded instead of truncated. Rounding is what

Re: Insert decimals with rounding

2005-07-20 Thread Scott Haneda
on 7/20/05 2:23 PM, sean c peters at [EMAIL PROTECTED] wrote: > Hi all. > I am trying to figure out if there is a way to configure MySQL so that when > inserts occur on decimal fields where the value being inserted has more > precision than the field specification, then the value inserted is roun

Insert decimals with rounding

2005-07-20 Thread sean c peters
Hi all. I am trying to figure out if there is a way to configure MySQL so that when inserts occur on decimal fields where the value being inserted has more precision than the field specification, then the value inserted is rounded instead of truncated. For example, if i have a column: Acres DE