Knowledge Walls
John Peter
Pune, Maharashtra, India
Remove decimal places without rounding in mysql using truncate with Example
27329 Views
TRUNCATE Method in MYSQL 
TRUNCATE Method in mysql which is truncates decimal places not doing round off values.

Example
SELECT
TRUNCATE(2.7443,2),
TRUNCATE(2.7443,0),
TRUNCATE(2.7443,3);
Output 
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details