First, I have a table with the next values:
Name Table: 10-0, Values: id, clave_radial, date_time, the_geom
I have the following SQL View:
SELECT * FROM "10-0" WHERE date_time BETWEEN
%firstDatetime% AND %secondDatetime%
And I'm always getting the same error:
SQL: ERROR: syntax error at or near "AND" Position: 63
What am I doing bad? Really I don't understand...
By the way, The regular expression to validate the datetimes is:
^(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})$
______________________________________
Estudiante de Ingeniería Civil en Computación,
Universidad de Talca.
_______________________________________
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users