Hi,
What is the difference between Currency and Decimal data types? "Available Data Types" topic in OS Help says nothing about it. It would seem that Currency should have by design 2 decimal places but the default value for Currency is (there) 0.0 and the example - 545870.025.....Regards
Tomasz
They are essentially the same. However, having a currency entity attribute will help you a bit while doing scaffolding patterns, as these fields will be automatically formatted as currency. And it kind of helps to document your data model, as you're adding a bit more information about the role of a specific attribute.
Good point.
the 0.0 is probably because of the trimming and you always need to format it anyways.
The example might be because of rounding/calculations, because it is a currency. You really don't want to lose decimals while calculating amounts.
Actually I rarely use Currency because of that and use Decimal anyways.
I will ask my little birds to explain it a bit more
https://sqlstudies.com/2014/06/02/what-is-the-difference-between-money-and-decimal194/
Barong,
That is not particularly helpful, as the Platform doesn't use MONEY in the database.
OK. This makes sense.
Regards
Does currency datatype in Outsystems takes care of currency conversion or any in built functions as such?
Hi Sai,
No, "Currency" is basically the same as "Decimal".