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 rounded > instead of truncated. > > For example, if i have a column: > Acres DECIMAL(14,3) NOT NULL DEFAULT 0 > > and i'm inserting the value '1.5467' > > currently, the value 1.546 is inserted. > > But i want the behaviour to round this number to 1.547 > > Is this possible, or will i have to do that manually (programmatically) for > all the decimal fields that i want to behave this way.
I think you can do it with the ROUND() function, using the precision argument. mysql> select ROUND(1.5467, 3); +------------------+ | ROUND(1.5467, 3) | +------------------+ | 1.547 | +------------------+ 1 row in set (0.00 sec) So it would be something like: INSERT into table SET foo = ROUND(1.5467, 3); -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]