[mapserver-users] Oracle SYSDATE in EXPRESSION

[Basques, Bob (CI-StPaul)]

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