Decimal Place precision, poss to store to 13 dec places?

[LucieLastic]

hi

Trying to store numbers accurately to 13 decimal places but Float type seems to truncate the number and couldn't get it to work using Decimal type.

Is it possible to store numbers (without any sort of round) to this precision?

Many thanks in advance,
Lou

www.radbmx.co.uk

 

[gmmastros]

>> couldn't get it to work using Decimal type.

Why not?

Here's an example that stores the number in a variable but would work just as well in a field.

Declare @Temp Decimal(28,13)

Set @Temp = 1234567890123.1234567890123

Select @Temp

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[AlexCuse]

Perhaps something like this?

select convert(decimal (15,13), MyColumn)

Ignorance of certain subjects is a great part of wisdom

 

[LucieLastic]

Thanks everyone, I stupidly hadn't allowed enough in the precision field! Now all working.

Thanks again.

www.radbmx.co.uk

 

[MissyEd]

I beleive you can use the decimal data type e.g. decimal(38, 15) will store what you wish. Caveat, Ive never used this in a production environment, so it would be a good idea to test it thoroughly.

There are some other issues with using these data types - see BOL.

"There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter

 

[MissyEd]

That'll teach me not to refresh before I post

"There are only two lasting bequests we can hope to give our children; one of these is roots, the other wings" - Hodding Carter