Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Date filter problem in PostgreSQL #214

Open
TomasPilar opened this issue Aug 8, 2015 · 1 comment
Open

Date filter problem in PostgreSQL #214

TomasPilar opened this issue Aug 8, 2015 · 1 comment

Comments

@TomasPilar
Copy link
Contributor

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.

@o5
Copy link
Owner

o5 commented Oct 14, 2015

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants