I tried this DATA statement successfully with Oracle: DATA "GEOLOC FROM (SELECT GEOLOC,OBJECTID,START_DATE, (SYSDATE-START_DATE)/365 as age FROM SPATIAL_TABLE) USING UNIQUE OBJECTID SRID 27700"
[AGE] can then be used in any styling. Martin -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Oracle-SYSDATE-in-EXPRESSION-tp5258709p5259649.html Sent from the Mapserver - User mailing list archive at Nabble.com. _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
