grido icon indicating copy to clipboard operation
grido copied to clipboard

Date filter problem in PostgreSQL

Open TomasPilar opened this issue 9 years ago • 1 comments

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.

TomasPilar avatar Aug 08 '15 15:08 TomasPilar

Please, include your grid definition or (better) fork https://github.com/o5/grido-examples and attach PostgreSQL init sql file.

o5 avatar Oct 14 '15 21:10 o5