Home > Archive > MySQL ODBC Connector > September 2005 > FROMAT function - German Notation









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author FROMAT function - German Notation
Benedikt Hartmann

2005-09-28, 1:23 pm

How can I display the result of the FROMAT function in german notation
like '#.###,##'?

I found no better way then this:
<code>
REPLACE(REPLACE(REPL
ACE( FORMAT(money,2),'.','x'),',','.'),'x',',') as
ge_money
</code>

does anybody know a solution?
thank's for help

Benedikt


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com