Timeline for Searching through dates query not working?
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 20, 2018 at 15:47 | comment | added | Rick James | @DojoDev 3-4 minutes? Something else needs fixing. Let's see the things I ask for in my previous Comment. | |
| Nov 20, 2018 at 6:19 | comment | added | DojoDev | indexing date_created makes the query a little faster but still in filtering the query takes 3-4 minutes to execute. By filtering i mean when i load the page and then apply another filter so on 2nd time query takes too much time now. | |
| Nov 20, 2018 at 6:18 | vote | accept | DojoDev | ||
| Nov 20, 2018 at 4:19 | comment | added | Rick James |
Grrr... I needed to know that it was INT instead of TIMESTAMP. See my update. If there are still issues, please provide a current SHOW CREATE TABLE, and EXPLAIN SELECT ....
|
|
| Nov 20, 2018 at 4:18 | history | edited | Rick James | CC BY-SA 4.0 |
Add the INT version
|
| Nov 19, 2018 at 7:02 | comment | added | DojoDev | check my updated question please. | |
| Nov 19, 2018 at 6:20 | comment | added | DojoDev |
in table we have entries for dates like 1446976737 which is unix timestamp and datatype for these fields is int and I'm comparing input like 2015-11-08 so putting quotes around "2015-11-08" will compare correctly?
|
|
| Nov 18, 2018 at 19:54 | comment | added | Rick James |
@DojoDev - I was wrong. Just add quotes around 2018-11-11. (Fixed my Answer.)
|
|
| Nov 18, 2018 at 19:53 | history | edited | Rick James | CC BY-SA 4.0 |
fix my advice and add example
|
| Nov 18, 2018 at 18:25 | comment | added | DojoDev |
I tried all of the above tricks none worked. I even tried the below SELECT e.id` AS id, e.first_name AS first_name, e.gender AS gender, e.email AS email, e.phone AS phone, e.age AS age, e.version AS version, e.evaluation_status AS evaluation_status, e.ip_address AS ip_address, e.date_created, e.date_updated AS date_updated FROM evaluation_client AS e WHERE e.date_created = "1446976737";`
|
|
| Nov 18, 2018 at 18:05 | history | answered | Rick James | CC BY-SA 4.0 |