Many thanks! 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%'
2014/1/20 Umberto Nicoletti <umberto.nicole...@gmail.com> > On Mon, Jan 20, 2014 at 2:44 PM, D. Nappo <domenico.na...@gmail.com>wrote: > >> Hi there, >> >> I couldn't figure out how to solve this. I have a layer so configured: >> >> LAYER >> NAME "layer" >> TYPE point >> CONNECTION "conn_string...." >> CONNECTIONTYPE ORACLESPATIAL >> TEMPLATE "templates/hotspot_template.html" >> 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" >> METADATA >> "wms_title" "WMS test" >> "wms_srs" "EPSG:4326" >> "wms_extent" "-180 -90 180 90" >> "wms_timeextent" "2000-01-01/2020-12-31" >> "wms_timeitem" "acq_date" >> "wms_timedefault" "2014-01-01" >> "wms_timeformat" "YYYY-MM-DD" >> > > > Try with this: > > "wms_timeformat" "DD-MM-YY" > > it is the default format Oracle expects when converting a string to a date > and no format has been explicitly provided. > > Hth, > Umberto > > > >> "wms_enable_request" "*" >> END >> CLASS >> SYMBOL 'circle' >> SIZE 2 >> COLOR 255 0 0 >> END >> END >> >> >> >> Now, the date column in the oracle table is the acq_date field. >> >> >> The problem is that Mapserver translates that with a wrong oracle query >> (which it works in postgreslq, I guess): >> >> SELECT OGR_FID,rownum, SHAPE FROM >> (SELECT OGR_FID, POINT as SHAPE, ACQ_DATE, ACQ_TIME, SATELLITE, >> CONFIDENCE, VERSION, BRIGHT_T31, FRP FROM gwsprd.HOT_SPOTS_MODIS) >> WHERE acq_date = '2014-01-16' >> >> >> The query above uses a wrong filter and it gives the error: >> >> ORA-01861: literal does not match format string >> >> >> How can I tell to Mapserver to use a correct query??? Or do I missing >> anyhting??? >> Something like: >> >> WHERE acq_date = to_date('2014-01-16','YYYY-MM-DD') >> >> _______________________________________________ >> mapserver-users mailing list >> mapserver-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> > >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users