Hello,
I am trying to truncate lat/long data. Here's my scenario:
These are numeric (10,8) data types first of all.
if my lat is 27.41317320 then I need to drop the zero to only return 27.4131732
Now, if my lat is this then I need to return the entire lat: 27.41317302
And if my lat is 27.41317300 then return 27.413173
I tried this: