convert latitude and longitude values from dms to dd in sql server -

convert latitude and longitude values from dms to dd in sql server -

i have latitude , longitude values in degreesminutesseconds(dms) 17264496n,78223862e.

i need convert decimaldegrees(dd) 17.8688,078.12547.

is there way convert dms dd.

in google search found dms conversion values have separate columns degrees, minutes, seconds degrees 17, minutes 26, seconds 44.

i got answer,we must first split dms value degrees,minutes , seconds in next way. have step1:create function takes dms latitude value parameter. step2:now function returns decimal grade value

alter function [dbo].[getlatitudeconversionfromdmstodd] ( @latitudeindms nvarchar(100) ) returns float begin declare @firsttwocharforstartlat nvarchar(100),@charelimforstartlat nvarchar(100), @remcharforstartlat nvarchar(100), @charelimcountforstartlat float, @degreetodecimalcalcforstartlat float select @firsttwocharforstartlat= left(@latitudeindms,2) select @charelimforstartlat=left(@latitudeindms,len(@latitudeindms)-1) select @remcharforstartlat=right(@charelimforstartlat,6) select @charelimcountforstartlat=((cast(@remcharforstartlat float))/600000) select @degreetodecimalcalcforstartlat=(cast(@firsttwocharforstartlat float))+@charelimcountforstartlat homecoming @degreetodecimalcalcforstartlat end --select dbo.getlatitudeconversionfromdmstodd('17264496n') --the output is:17.4408266666667

sql-server sql-server-2008 type-conversion