On Saturday 15 November 2008 00:04:13 Karel Maesen (JIRA) wrote: > CQL datetime values not properly translated in Oracle > ----------------------------------------------------- > > Key: GEOT-2156 > URL: http://jira.codehaus.org/browse/GEOT-2156 > Project: GeoTools > Issue Type: Bug > Affects Versions: 2.5.1 > Environment: Linux (Ubuntu 8.10), Java 1.5, Oracle Spatial 10g XE > Reporter: Karel Maesen > > > When using Geoserver's CQL_FILTER property a request like > > "ZONE_VALID_FROM BEFORE 2008-09-09T17:00:00Z" > > Gets translated to > > "ZONE_VALID_FROM < '2008-09-09'" > > Two things are wrong with this. 1) The hours:minutes values are ignored. It works OK in trunk. I will update my box with 2.5.1 tag to reproduce the bug. > 2) > this only works when the default date format string is set to "YYYY-MM-DD" > which is not always the case (e.g. US locale). Well, ... CQL is OGC complaint, the specification ("OGC Catalogue Service Specification v2") says that the <full-date> must be written following the rule:
<full-date> := <date-year> "-" <date-month> "-" <date-day> so, your chance is that the client module (habitually the user interface) handles the date, taking into account the locale, and transforms it to OGC CQL date format. cheers -- Mauricio Pazos Director www.axios.es ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
