Database Data Types

Question

What database data type do I need to use to store a numerical value with 18 digits after the decimal place? I've tried double and float but it doesn't work it only shows 16 digits after the decimal place. I'm using MS SQL Server 2005 and 2008.

Gordon Linoff · Accepted Answer · 2013-08-08 21:16:19Z

3

Assuming your values are not too big, you want to use DECIMAL. Something like DECIMAL(20, 18) (adjust the first value for the total number of digits in the number).

You can read about it here.

answered Aug 8, 2013 at 21:16

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

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

2 Comments

user1302054 Over a year ago

What if the total number of digits vary?

Gordon Linoff Over a year ago

@user1302054 . . . Just use a large enough value for the first digit . . . DECIMAL(30, 18) should be big and precise enough for most measurements.

Collectives™ on Stack Overflow

Database Data Types

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related