Timeline for MySQL : DATE_FORMAT() vs. SUBSTR()
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 19, 2017 at 11:36 | comment | added | Joffrey | OK thank you. I just another question about index in my case : dba.stackexchange.com/questions/193513/… :-) | |
| Dec 19, 2017 at 11:08 | comment | added | ypercubeᵀᴹ | The index would help, even your existing query. | |
| Dec 19, 2017 at 11:03 | vote | accept | Joffrey | ||
| Dec 19, 2017 at 11:03 | comment | added | Joffrey | OK thank you so much, I'm gonna try it. Now, the query takes up to 60seconds... | |
| Dec 19, 2017 at 11:00 | comment | added | ypercubeᵀᴹ | Probably a bit less. Not much but yes, less. Removing the crc32() calls will be another gain. Adding the index much better. How long does the query takes now? | |
| Dec 19, 2017 at 10:58 | comment | added | Joffrey |
Thanks ! So DATE() will use less resources than DATE_FORMAT() ?
|
|
| Dec 19, 2017 at 10:56 | history | answered | ypercubeᵀᴹ | CC BY-SA 3.0 |