today I've a question about the WHERE part in a select query.
We've a table with some date fields in there and want to select
records between dataA and dateB.
Currently we use:
SELECT ... WHERE col_date BETWEEN DATETIME'18.12.2015 00:00:00' AND DATETIME'18.12.2015 23:59:59'
On some client installations we're getting an error like:
"Date-time value "18.12.2015 23:59:59" is invalid. Illegal symbol at "3" position.
As far as I understand this means that the "." is wrong and some other char is expected.
This also works for the most of our clients but some get this strange error.
Our project currently uses version 5.8.8 and connects to a local db (no VServer).
Is there a way to track down the problem?
The db settings are: dateformat = "dmY" and the seperator is "." .
Is it maybe possible to use something like that:
SELECT ... WHERE col_date BETWEEN '18.12.2015 00:00:00' AND '18.12.2015 23:59:59'
Is it more safe to use the DATETIME before the a and b values of BETWEEN ?
At the moment we cannot upgrade to version 6 of valentina as we're working on that
for the new year. (subscription is valid).
Thank you in advance.