Understanding Datetime column

There are N number of questions asked in the forums about handling dates in query Most of the people who ask questions dont understand how datetime column works in SQL Server Some of the questions frequently asked are about 1 using dates in the WHERE caluse 2 formatting dates using SQL 3 inserting dates to the table with specific date format etcIn this series of blog posts, I would explain them