Format decimal in mySQL?

Question

I have number with folowing format 12.25564 The format on field in mysql is DECIMAL(12,5). I want to export file from this table and the format on this decimal number is 12.26. How can I formated this number with MySQL in SELECT ? Thanks in advance !

Saad · Accepted Answer · 2012-04-23 07:12:34Z

3

You can use the MySql Round Method:

SELECT ROUND(12.25564, 2)

answered Apr 23, 2012 at 7:12

Saad

1689 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Format decimal in mySQL?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related