One of the most frequently asked questions by SQL Server Developers is about the SQL Server DateTime column. Out of these, questions like Retrieving Date in a particular format, Saving Dates, Formatting Dates, Date Ranges etc. are most common.
SQL Server MVP Madhivanan recently wrote a four part series covering most of these questions. They are just awesome and full of SQL Server DateTime goodness. I highly recommend SQL Server Developers to read this series to understand DateTime Operations. Here is the list: