Changes between Version 23 and Version 24 of UsersWikiplpgsqlfunctions

Timestamp:

Jan 20, 2011, 7:50:10 PM (13 years ago)

Author:

robe

Comment:

—

UsersWikiplpgsqlfunctions

@@ -68 +68 @@
 [http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/114/converting-google-earth-formatted-longitude-latitude-points-to-decimal-degrees Converting Google Earth Formatted Longitude/Latitude points to decimal degrees] 
 Example use: 
+
+{{{
+SELECT round(dms2dd('43° 0''50.60"S'),9) as latitude,
+       round(dms2dd('147°12''18.20"E'),9) as longitude;
+}}}
+
+
+
 {{{
 CREATE OR REPLACE FUNCTION DMS2DD(strDegMinSec varchar)