[postgis-users] Cut lat/lon to six decimal digits

[Carsten Hogertz]

Hi everyone,
I've got the following SQL to extract the lat/lon of a polygone:

SELECT
ROW_NUMBER () over () as id,
name,
geom,
ST_Y(geom) as lat,
ST_X(geom) as lon
FROM (SELECT name, (ST_DumpPoints(geom)).* FROM timezones20032013) as foo

It gives me back the lat and lon as a number with a lot of digits, e.g.:
42.4734992980957
1.71096694469452

Instead what I need is:
42.473499
1.710967

How could I change my SQL to get the result cut/rounded?

Any help would be appreciated.

Thanks in advance
Carsten
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130416/3c477338/attachment.html>