Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting Date
Message
From
13/06/2008 11:32:30
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Converting Date
Miscellaneous
Thread ID:
01323855
Message ID:
01323866
Views:
13
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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform