kapil_kk (3/11/2013)
Hi,can someone plz explain it in a more simple manner..... explanation in QOTD is very inscrutable for me:cool:
Inscrutable , is that the right word :ermm:
well, as explained in the explanation ..
1.
The two digit year cutoff option specifies an integer from 1753 to 9999 that represents the cutoff year for interpreting two-digit years as four-digit years.
So, for sql server to interpret Two digit year as Four digit year
2.
The default time span for SQL Server is 1950-2049,
It means , if you anything in between the above range .. it will interpret as current century ..
50 is 1950
51 is 1951
49 is 2049
48 is 2048
is that clear enough ??? 🙂
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: