Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Decimal comma (,) instead od point(.) in table
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Decimal comma (,) instead od point(.) in table
#58727
Decimal comma (,) instead od point(.) in table 7 Years, 6 Months ago Karma: 0
I'm using ARI Data table as the table, and the results show the numbers with (.) for decimals. I need them to be commas (,) (European format). Also, I will need thousands to be points (.) and not commas (,)

This is currently the result (on joomla article and excel export):
1,100.00
I need this:
1.100,00

I already tried
Code:

CONVERT(value, DECIMAL(10,2))
but it has no effect. In the database it's formatted correctly
The administrator has disabled public write access.
 
#58728
Re:Decimal comma (,) instead od point(.) in table 7 Years, 6 Months ago Karma: 0
Never mind, I found it:
Code:

FORMAT(value,2,'de_DE')

And yes, you have to use the German code. I tried using the Italian one and it didn't work.
The administrator has disabled public write access.
 
Go to topPage: 1