Timeline for How to convert Geometry type column to degree Minutes Second in SQL Server 2008 R2
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 4, 2015 at 14:31 | comment | added | Russell at ISC | @Royi, can use it with either, see Baodad below for using geography. | |
| Feb 4, 2015 at 8:56 | comment | added | Royi Namir | Shouldn't this be used with geography rather than geometry ? but geography doesn't have STX.... | |
| Jul 26, 2013 at 16:54 | vote | accept | Gunner | ||
| Jul 26, 2013 at 16:52 | history | edited | Russell at ISC | CC BY-SA 3.0 |
added 740 characters in body
|
| Jul 26, 2013 at 16:49 | comment | added | Russell at ISC | Remove the "CASE WHEN geom.STX < 0 then '-' ELSE '' END +" at the start and add "+ CASE WHEN geom.STX < 0 then ' W' ELSE ' E' END" at the end. Similarly for STY < 0 is S otherwise N. Note ampersand omitted because the comment editor yacked on it. | |
| Jul 26, 2013 at 16:42 | comment | added | Gunner | thanks man but what about N S E W value...??? | |
| Jul 26, 2013 at 15:28 | history | edited | Russell at ISC | CC BY-SA 3.0 |
format
|
| Jul 26, 2013 at 15:27 | history | undeleted | Russell at ISC | ||
| Jul 26, 2013 at 15:21 | history | deleted | Russell at ISC | via Vote | |
| Jul 26, 2013 at 15:20 | history | answered | Russell at ISC | CC BY-SA 3.0 |