[mapserver-users] Oracle SYSDATE in EXPRESSION

[Basques, Bob (CI-StPaul)]

All Oracle Guru’s,

How do I handle an expression for doing a timed query in Oracle:

CLASS
EXPRESSION ('[indate] > SYSDATE - 1825')
COLOR 255 255 254
OUTLINECOLOR 0 0 0
      SIZE 10
      SYMBOL 'circle'
NAME "PW Sidewalk Permits"
    END

I want to get all the Permits up to 5 years old to plot.  What should the EXPRESSION line look like above.  I’ve tried all sort of different combinations of quoting, etc.  I either get everything, or nothing.

Thanks

bobb


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160329/fc998183/attachment.htm>