[mapserver-users] Oracle SYSDATE in EXPRESSION

Mon Apr 4 23:36:59 PDT 2016

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.