Convert data type DECIMAL to ST_GEOMETRY

[former_member550544]

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.

Regards,

Ricky

[lbreddemann]

Search before posting questions!

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

[ravicondamoor]

update <table> set latlong = NEW ST_Point(long,lat) where...

should work. latlong is of type ST_GEOMETRY