It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when doing some checks on some billable data that had been captured: select * from sometable where somedate between ‘6/1/2011’ and ‘7/1/2011’ Nine times out of ten when you see that statement what they meant was: […]
Read more "Subtle Errors When Using Dates-Part 2"
Note: My original code was not helpful (wrong!), the corrected version is shown below. I was reviewing some code recently that has been in production for a while and I saw something like this: delete from sometable where datecol > getdate() – 3 …..lots of work here, several seconds to a minute Insert Into SomeTable….new rows […]
Read more "Subtle Errors When Using Dates-Part 1"
Instructables has a Paracord contest going that requires some portion of a project include paracord (often referred to as 550 cord for the breaking strength of 550 lbs. I don’t have a good idea yet, hoping one appears before the April 11 submission deadline. Thought I’d share, most of us in IT enjoy a challenge […]
Read more "Instructables Contest: Paracord"