Message
From
13/06/2008 11:32:30
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
Altamahaw-Ossipee, North Carolina, United States
To
13/06/2008 11:23:04
Miscellaneous
Thread ID:
01323855
Message ID:
01323866
Views:
17
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)
>SELECT CONVERT(varchar(8),@Test,112)