<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
All Oracle Guru’s,
<div class=""><br class="">
</div>
<div class="">How do I handle an expression for doing a timed query in Oracle:</div>
<div class=""><br class="">
</div>
<div class="">
<div class=""><span class="Apple-tab-span" style="white-space:pre"></span><font face="Courier New" class="">CLASS</font></div>
<div class=""><font face="Courier New" class=""><span class="Apple-tab-span" style="white-space:pre"></span><font color="#ff2600" class=""><b class="">EXPRESSION ('[indate] > SYSDATE - 1825')</b></font></font></div>
<div class=""><font face="Courier New" class=""><span class="Apple-tab-span" style="white-space:pre"></span>COLOR 255 255 254</font></div>
<div class=""><font face="Courier New" class=""><span class="Apple-tab-span" style="white-space:pre"></span>OUTLINECOLOR 0 0 0</font></div>
<div class=""><font face="Courier New" class=""> <span class="Apple-tab-span" style="white-space:pre">
</span>SIZE 10</font></div>
<div class=""><font face="Courier New" class=""> <span class="Apple-tab-span" style="white-space:pre">
</span>SYMBOL 'circle'<span class="Apple-tab-span" style="white-space:pre"> </span>
</font></div>
<div class=""><font face="Courier New" class=""><span class="Apple-tab-span" style="white-space:pre"></span>NAME "PW Sidewalk Permits"</font></div>
<div class=""><font face="Courier New" class=""> <span class="Apple-tab-span" style="white-space:pre">
</span>END</font></div>
</div>
<div class=""><br class="">
</div>
<div class="">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.</div>
<div class=""><br class="">
</div>
<div class="">Thanks</div>
<div class=""><br class="">
</div>
<div class="">bobb</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
</body>
</html>