[OpenLayers-Users] OGC Filter problem

[pask23]

maybe I have found the error. Geoserver to do this query on the DB:
SELECT "node_id","datetime","geom".STAsBinary() as "geom"
  FROM "v_dati_sensori_geom_BNU1" WHERE  "datetime" BETWEEN '2013-01-3
16:45:53.000' AND '2013-01-10 16:45:58.000'

but this not work because the right query on SQL SERVER is:

SELECT "node_id","datetime","geom".STAsBinary() as "geom"
  FROM "v_dati_sensori_geom_BNU1" WHERE  "datetime" 
  BETWEEN convert(datetime, '2013-01-3 16:45:53.000', 30)  AND
convert(datetime, '2013-01-10 16:45:58.000', 30)

Workaround for this problem?



--
View this message in context: http://osgeo-org.1560.n6.nabble.com/OGC-Filter-problem-tp5026627p5026705.html
Sent from the OpenLayers Users mailing list archive at Nabble.com.