MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Format a number with grouped thousands
Posted by: andre cavalcante
Date: May 31, 2006 07:46PM

Hi everyone,

I want to format a number but i want to use comma (',') as decimal separator, and dot ('.') as thousand separator.

But when i use FORMAT(x, d) it comes always x,xxx,xxx.xx

How can i change it?

Thanx

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Format a number with grouped thousands
andre cavalcante
May 31, 2006 07:46PM
Re: Format a number with grouped thousands
Bob Field
June 03, 2006 01:52PM
Re: Format a number with grouped thousands
Turan YANIK
June 21, 2006 01:32AM
Re: Format a number with grouped thousands
Bob Field
June 21, 2006 08:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.