Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Nah... I just bet that this is some dev, that doesn't know how to deal with dates.

I had a recently "senior" dev give me a SQL query with similar where clause, when asked to query data after Sept 1, 2022 (where moy >= 9 and dom => 1 and year => 2022)



In case anyone is confused, the problem is that dates loop, such that moy=1, dom=1, year=2023 will not match despite being greater than Sept 1, 2022. Technically, then, if you wanted this logic to work you would have to add a second “or” clause that handles the edges missed, e.g. (moy >= 9 AND year = 2022) OR (year > 2022) though you would need a different edge case if your dom wasn’t 1. The easier approach, of course, is to just compare dates or timestamps directly.


What good reason is there for hard coding dates that shutdown trains?


That's when the compressor's going to fail, obviously. ;D


Right. How did that famous adage go? "The best way to predict the future is to invent it."


The best way to predict a crime is to commit it.

(with apologies to Alan Kay who coined the original saying)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: