Knowledge Walls
John Peter
Pune, Maharashtra, India
Number and Exponential number rounding issue in Mysql with Example
3571 Views
MySQL Example
SELECT ROUND(4.5),ROUND(-4.5);
# Returns 5 and -5

SELECT ROUND(4.5E0),ROUND(-4.5E0);
# Returns 4 and -4
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