What is the data type for Currency in SQL Server?

Question

What is the data type to the currency value in SQL Server.

e.g: I want to store $11.23.

Can I use money type and addtionally will it store the $ symbol?

any numeric data type will not store any symbol if you put symbol you have to phase lot of problem to calculate that amount — wiretext
– wiretext, Commented Sep 10, 2015 at 8:56
possible duplicate of Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server? — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Sep 10, 2015 at 9:30
There's no point in using money, it doesn't store any currency info, has limited range and a hard-coded precision of 4. Typically a decimal with a specific range and precision is used, eg decimal(9,2) specifies 9 digits, 2 of which are decimals. money more for for compatibility with VB6 and OLEDB than anything else — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Sep 10, 2015 at 9:38

Alfaiz Ahmed · Accepted Answer · 2016-10-07 09:50:35Z

11

DECLARE @Price Decimal(18,2) = 11.23 SELECT FORMAT(@Price,'c','en-US') AS 'CURRENCY IN US Culture'

answered Oct 7, 2016 at 9:50

Alfaiz Ahmed

1,7261 gold badge13 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paolo · Accepted Answer · 2015-09-10 09:07:16Z

5

answering to the question in the title, the datatype for currency is MONEY.

the money datatype will store the information only, without the format: in your example the information is 11.23 so that's what is saved into the database.

the $ sign is part of the format so it will not be stored into the money field.

the usual solution is to have a MONEY field for the amount and a VARCHAR field for the currency symbol/name.

answered Sep 10, 2015 at 9:07

Paolo

2,2731 gold badge17 silver badges20 bronze badges

3 Comments

Panagiotis Kanavos Over a year ago

money isn't useful as it doesn't store any currency info. It's simply a decimal type with less precision than a decimal. It also doesn't allow you to specify precision, eg when values are allowed to only have 2 decimals. What does 21.3455 $ mean?

Paolo Over a year ago

@PanagiotisKanavos that's your opinion, mine is different. if you need to change precision and scale then go with other datatypes but if MONEY (knowing its specifications) fits then can be a valid choice as any other datatype.

Aswath Over a year ago

wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_money

Gopal Krishna Ranjan · Accepted Answer · 2015-09-10 09:38:14Z

I think the best way to store the currency is to use either NUMERIC or DECIMAL data types as these values participates in calculations. If we use NVARCHAR to allow the storage with symbol like ($), it will cost extra during calculations when use in WHERE clause. We can choose the precision and scale accordingly.

iknow · Accepted Answer · 2020-09-17 10:10:05Z

0

it should be DECIMAL(,) OR NUMERIC in SQL. eg DECIMAL(20,2)

edited Sep 17, 2020 at 10:10

iknow

10.3k15 gold badges47 silver badges81 bronze badges

answered Sep 17, 2020 at 2:10

Ashutosh

271 silver badge7 bronze badges

Collectives™ on Stack Overflow

What is the data type for Currency in SQL Server?

4 Answers 4

Comments

3 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

3 Comments

Comments

Comments

Linked

Related