>Why did that work? Style 112 is in the format YYMMDD, not YYYYMMDD. Is it because you put a value of 8 for the varchar?
>
>>SELECT CONVERT(varchar(8),@Test,112)
As you see there is two styles:
1st column is Without century, second one is with century:
So with 12 you will get YYMMDD with 112 you'll get YYYYMMDD
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.