Sql Clr User Defined Type parsing a float and losing precision

Question

I've got a Clr user defined type that takes a string of values sepertated by a comma.

I'm losing a little bit of precision when converting to this type, I've narrowed it down to this line of code:

cast(cast(nlinkjt as nvarchar(100)) + ',' +cast(avglrwf as nvarchar(100)) + ',' + cast(avglrwfjt as nvarchar(100)) as dbo.CLRJourneyTime) as clrJT

output = 29.9376,5.29633e-005,0.00158559

but the orignal values are like so:

nlinkjt = 29.9376097988521  = cast(nlinkjt as nvarchar)  = 29.9376
avglrwf = 5.29632961843163E-05  = cast(avglrwf as nvarchar) = 5.29633e-005
avglrwfjt =  0.00158559449482709  = cast(avglrwfjt as nvarchar) = 0.00158559

how can i convert the floats to a string in full?

Or is there another way of declaring a new dbo.CLRJourneyTime like you would in .net like so:

'new dbo.CLRJourneyTime(nlinkjt , avglrwf , avglrwfjt ) as clrJT'

Hath · Accepted Answer · 2008-11-05 14:34:37Z

1

Ok, Just found out that the float column only stored to about 4 decimal places anyways.. so it probably wont matter.

answered Nov 5, 2008 at 14:34

Hath

12.8k7 gold badges39 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Sql Clr User Defined Type parsing a float and losing precision

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related