Timeline for MySQL Coalesce date missing results, why?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 22, 2019 at 17:13 | history | edited | Rick James | CC BY-SA 4.0 |
more
|
| Dec 22, 2019 at 17:01 | history | edited | Rick James | CC BY-SA 4.0 |
fix bad data
|
| Dec 22, 2019 at 16:58 | comment | added | Rick James | @James - I picked a random table with some junk data. And it was junk. | |
| Dec 22, 2019 at 7:57 | comment | added | James |
Is it me or does just_date should be 2016 instead of 2006. Because the 3rd query SELECT dt, just_date FROM dtts WHERE COALESCE(just_date, '9999-1-1') between '2016-07-31' and '2016-07-31'; gave me result. fiddle here
|
|
| Dec 21, 2019 at 8:08 | comment | added | Mr Redstoner | Regarding the usage of BETWEEN, that is essentially a different part of the project which I may look into improving. Might in fact have to, thanks for the solution before problem | |
| Dec 21, 2019 at 1:49 | history | edited | Rick James | CC BY-SA 4.0 |
added 1256 characters in body
|
| Dec 21, 2019 at 1:20 | history | edited | Rick James | CC BY-SA 4.0 |
added 68 characters in body
|
| Dec 21, 2019 at 1:13 | history | answered | Rick James | CC BY-SA 4.0 |