QUery help

Thats the way SQLServer interprets dates. Anything below 50 it will interpret century as 20 if not explicitly passed by default.

If you want to change it you need to tweak server configuration value using sp_configure

http://msdn.microsoft.com/en-IN/library/ms191004.aspx

Otherwise explicitly pass the year value in YYYY format

---

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

----------------------------

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page