Thanks Martin, I'll take a look at it again. I thought I had tried all possible combinations of brackets/quoting, etc. though . . .
bobb > On Apr 5, 2016, at 1:36 AM, Martin Icking <martin.ick...@bentley.com> wrote: > > 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 > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users