3 ms·

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,

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)

CryptoBanker 3y ago
What good reason is there for hard coding dates that shutdown trains?
- thaumasiotes 3y ago
  That's when the compressor's going to fail, obviously. ;D
  - TeMPOraL 3y ago
    Right. How did that famous adage go? "The best way to predict the future is to invent it."
    - raphman 3y ago
      The best way to predict a crime is to commit it. (with apologies to Alan Kay who coined the original saying)
lstamour 3y ago
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.