<div dir="ltr">Many thanks!<div>It helped: the default date format in our system is DD-Mon-RR and I found it out with SELECT * FROM nls_database_parameters WHERE parameter LIKE '%DATE%'</div><div><br></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2014/1/20 Umberto Nicoletti <span dir="ltr"><<a href="mailto:umberto.nicoletti@gmail.com" target="_blank">umberto.nicoletti@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote"><div class="im">On Mon, Jan 20, 2014 at 2:44 PM, D. Nappo <span dir="ltr"><<a href="mailto:domenico.nappo@gmail.com" target="_blank">domenico.nappo@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">Hi there,<div><br></div><div>I couldn't figure out how to solve this. I have a layer so configured:</div>
<div><br></div><div><div>LAYER</div><div> NAME "layer"</div><div> TYPE point</div>
<div> CONNECTION "conn_string...."</div><div> CONNECTIONTYPE ORACLESPATIAL</div><div> TEMPLATE "templates/hotspot_template.html"</div><div> DATA "SHAPE FROM (SELECT POINT as SHAPE, ACQ_DATE, ACQ_TIME, SATELLITE, CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM gwsprd.HOT_SPOTS_MODIS) using unique OGR_FID"</div>
<div> METADATA</div><div> "wms_title" "WMS test"</div><div> "wms_srs" "EPSG:4326"</div><div> "wms_extent" "-180 -90 180 90"</div>
<div> "wms_timeextent" "2000-01-01/2020-12-31"</div><div> "wms_timeitem" "acq_date"</div><div> "wms_timedefault" "2014-01-01"</div>
<div> "wms_timeformat" "YYYY-MM-DD"</div></div></div></blockquote><div><br></div><div><br></div></div><div>Try with this:</div><div><br></div><div>"wms_timeformat" "DD-MM-YY"<br>
</div><div><br></div><div>it is the default format Oracle expects when converting a string to a date and no format has been explicitly provided.</div><div><br></div><div>Hth,</div><div>Umberto</div><div><br></div><div> <br>
</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div class="im"><div dir="ltr"><div><div> "wms_enable_request" "*"</div>
<div> END</div><div><span style="white-space:pre-wrap"> </span>CLASS</div>
<div> SYMBOL 'circle'</div><div> SIZE 2</div><div> COLOR 255 0 0</div><div> END</div><div> END</div></div><div><br></div><div><br></div><div><br></div><div>Now, the date column in the oracle table is the acq_date field.</div>
<div><br></div><div><br></div><div>The problem is that Mapserver translates that with a wrong oracle query (which it works in postgreslq, I guess):</div><div><br></div><div><div>SELECT OGR_FID,rownum, SHAPE FROM </div><div>
(SELECT OGR_FID, POINT as SHAPE, ACQ_DATE, ACQ_TIME, SATELLITE, CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM gwsprd.HOT_SPOTS_MODIS) </div><div>WHERE acq_date = '2014-01-16'</div></div><div><br></div><div><br></div>
<div>The query above uses a wrong filter and it gives the error:</div><div><br></div><div>ORA-01861: literal does not match format string<br></div><div><br></div><div><br></div><div>How can I tell to Mapserver to use a correct query??? Or do I missing anyhting???</div>
<div>Something like:</div><div><br></div><div>WHERE acq_date = to_date('2014-01-16','YYYY-MM-DD')</div></div>
<br></div>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></blockquote></div><br></div></div>
</blockquote></div><br></div>