grido
grido copied to clipboard
Date filter problem in PostgreSQL
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.
Please, include your grid definition or (better) fork https://github.com/o5/grido-examples and attach PostgreSQL init sql file.