2 ms·
So the folks who did this complained about a bad DB (needing indexes) but then failed to convert the DOB's to date types.
by whalesalad 11y ago
So the folks who did this complained about a bad DB (needing indexes) but then failed to convert the DOB's to date types.
- yAnonymous 11y agoMaybe it's really stored as text?
- whalesalad 11y agoYeah but a simple query can add a column, copy the data while parsing it into a native date and then drop the original column. It can all be in a transaction too so that if there is a failure nothing is lost. I was mainly referring to the high and mighty attitude about fixing their broken db. If you're gonna fix it, it's all or nothing in my book.
- butler14 11y agoOnly on HN.
- yAnonymous 11y agoTrue. Although showing how unprofessionally the data is kept makes a good point, too.