karelog
asked on
MySql Number Format
Hello everybody!
I'm making a query in MySql 5.
MySql default decimal separator is the dot (.), However, I need that in my query comes as a decimal separator, a comma (,).
any idea on how to achieve this?
in advance, many thanks!
I'm making a query in MySql 5.
MySql default decimal separator is the dot (.), However, I need that in my query comes as a decimal separator, a comma (,).
any idea on how to achieve this?
in advance, many thanks!
ASKER
I've seen that link in many places.
this is my problem:
Select myDouble FROM myTable;
It brings me:
**************
* myTable *
**************
* 10 *
* 1.1 *
* 10.5 *
**************
I need that that 1.1 and 10.5 be in this format: 1,1 and 10,5
(yes, using comma a decimal separator)
I don't see how the format sentece would help me to achieve that D:
this is my problem:
Select myDouble FROM myTable;
It brings me:
**************
* myTable *
**************
* 10 *
* 1.1 *
* 10.5 *
**************
I need that that 1.1 and 10.5 be in this format: 1,1 and 10,5
(yes, using comma a decimal separator)
I don't see how the format sentece would help me to achieve that D:
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks ;:D
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_format