@willie Then again, I spend every day all day staring at SQL, and there’s more than one way to skin a cat, and SQL is probably the wrong way
@willie True. I was referring more to extracting the date to it’s own column, and the time to it’s own, so that = would work on an index.
@willie Yeah, that’s a crime. Slap an index on that thing and save the world a CPU or two.
@willie Absolutely, plus you’re just asking for errors in conversion.
@willie I disagree, so long as you have a parameter that can adjust that DATE (ala DATE_ADD). “Show me actions within the past X days”.