I have a requirement in which need to store latitude values only upto 6 decimal places after decimal point without rounding off
for example
latitude value is: 32.8912345 then should store as 32.891234
latitude value is 33.2345 then should store as itsi 33.2345 as it ihas less than six digits after decimal point.
in sql server i intially kept data type of latitude column as varchar(11)
in c sharp also i used string variable
and have written the following code
if (lat.Contains("."))
{
string[] tempStr1 = lat.Split('.');
string GoogleLatitude=string.Empty;
if (tempStr1[1].Length > 6)
{
GoogleLatitude = tempStr1[0] + "." + tempStr1[1].Substring(0, 6);
}
else
{
GoogleLatitude = lat;
}
}
else
{
GoogleLatitude = lat;
}
please do let me know how this can be achieved by using deciam(9,2) as datatype for sql column and without using split functions.