user1765862
user1765862

Reputation: 14145

format decimal to store 6 decimals

I'm using decimals to store longitute and latitude. Without any config in asp.net mvc4 form I'm getting in mssql db value like this (with losing last digit)

48.42920

and I should save this as

48.429201

Question is how to format decimal to meet this requirement?

THanks

Upvotes: 1

Views: 167

Answers (1)

user1765862
user1765862

Reputation: 14145

Inside mssql field should be set as decimal(N,6). 6 is the precision

Upvotes: 2

Related Questions