First, I have a table with the next values:
Name Table: 10-0, Values: id, clave_radial, date_time, the_geomI 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: 63What 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})$
أكثر...
Name Table: 10-0, Values: id, clave_radial, date_time, the_geomI 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: 63What 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})$ أكثر...