This post follows my blog post Understanding datetime column part I Date Formats Unambiguous formats YYYYMMDD HH:MM:SS YYYY-MM-DDTHH:MM:SS Ambiguous formats DD/MM/YYYY MM/DD/YYYY DD-MM-YYYY MM-DD-YYYY YYYY-MM-DD etc Someone wants to input dates in DD/MM/YYYY Read More......(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2010/06/03/9032.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9032" width="1" height="1">