[mapserver-users] Mapserver WMS time support with Oracle
Umberto Nicoletti
umberto.nicoletti at gmail.com
Mon Jan 20 10:33:17 PST 2014
On Mon, Jan 20, 2014 at 2:44 PM, D. Nappo <domenico.nappo at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20140120/84ac1525/attachment.htm>
More information about the MapServer-users
mailing list