Thread: Readin money type into java BigDecimals

Readin money type into java BigDecimals

From
Lincoln Spiteri
Date:
Hello,

I am having trouble creating java BidDecimal objects from data stored in
postgres as money. The problem seems to be due to formating of money
inpostgres (eg $12,000.00) which cannot be parsed by  java.

Is there anyway I can change the formating of the money type in
postgres, or should I use a different type to represent money for the
sake of compatability.

Regards

Lincoln Spiteri

STMicroelectronis, Malta