Skip to Content

Convert data type DECIMAL to ST_GEOMETRY

Hi Folks,

I have two columns in decimals for Latitude and Longitude data. How do I convert the two columns into one column having ST_GEOMETRY data type?

For ex:

Latitude (Decimal) = '10.3121'

Longitude (Decimal) = '15.2030'

Convert to:

LongLat (ST_GEOMETRY) = (10.3121 15.2030)

Appreciate if you can help? Please provide SQL Script or expression.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers