Regarding data type

Rajkiran Swain9y ago

https://stackoverflow.com/questions/582797/should-you-choose-the-money-or-decimalx-y-datatypes-in-sql-server

0

Narinder Singh9y ago

I already use a decimal(18,3) type in sql but when query get data on a pge then the 1000 amount show as a 10000.000

0

Manikandan Murugesan9y ago

As it is described at decimal as

The decimal keyword indicates a 128-bit data type. Compared to floating-point types, the decimal type has more precision and a smaller range, which makes it appropriate for financial and monetary calculations.

You can use a decimal as follows:

decimal myMoney = 300.5m;

0