Knowledge Walls
John Peter
Pune, Maharashtra, India
Remove decimal places without rounding in mysql using truncate with Example
13151 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 
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  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