[mapserver-users] Oracle SYSDATE in EXPRESSION
Basques, Bob (CI-StPaul)
bob.basques at ci.stpaul.mn.us
Tue Apr 5 08:45:04 PDT 2016
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.icking at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
More information about the MapServer-users
mailing list