Skip to Content

Convert data type DECIMAL to ST_GEOMETRY

Feb 21 at 12:29 AM


avatar image

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.



10 |10000 characters needed characters left characters exceeded

Search before posting questions!

By simply reading SAP HANA Spatial Reference you can work it out yourself, instead of just dumping your requirement here.

* Please Login or Register to Answer, Follow or Comment.

0 Answers