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

Reply via email to