You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi,
i used last PostgreSQL database and yesterday i was enabled filter for date column. Unfortunately it was thrown out fatal excepsion: "An exception occurred while executing 'SELECT COUNT(*) ... WHERE c0_.updated_at LIKE '08.08.2015%') ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.".
PostgreSQL doesn't use implicit type cast of date to string in using LIKE, like MySQL do.
I think that the best solution is used comparison operator BETWEEN. If i pick one day form datepicker i need results for e.g.: 08.08.2015 00:00:00 - 08.08.2015 23:59:59, so BETWEEN is good solution for this.
The text was updated successfully, but these errors were encountered:
Hi,
i used last PostgreSQL database and yesterday i was enabled filter for date column. Unfortunately it was thrown out fatal excepsion:
"An exception occurred while executing 'SELECT COUNT(*) ... WHERE c0_.updated_at LIKE '08.08.2015%') ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts."
.PostgreSQL doesn't use implicit type cast of date to string in using
LIKE
, like MySQL do.I think that the best solution is used comparison operator
BETWEEN
. If i pick one day form datepicker i need results for e.g.: 08.08.2015 00:00:00 - 08.08.2015 23:59:59, soBETWEEN
is good solution for this.The text was updated successfully, but these errors were encountered: