monpara.sanjay (2/8/2012)

---

Thanks to clarify

I am using SQL Server 2005.

Steve Jones - SSC Editor (2/2/2012)

---

SQL 2005 is out of support, over 5 years old. At this point, you should have heard of DATE as a data type. If not, you should be learning what's new, or slightly new.