Dates in MS SQL Server

Coming from Oracle, dates give me all kinds of trouble in MS SQL Server. Thing just don't work the way I want them too. Fortunately, Gary Larson has a really nice overview on how to work with dates in SQL Server.

Thoughts from the middle seat on a crowded flight

"Glad I'm not claustrophobic...am I?"