Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
smalldatetime convert to varchar
I'm replying to my own message. I had a variable defined wrong. I had to change that declaration from varchar to smalldatetime. LOL- GrocExp
- Post #2
- Forum: Microsoft SQL Server: Programming
-
smalldatetime convert to varchar
Why when I use this statement... SELECT CONVERT(varchar,'Jun 01 2001',101) ...the result is...Jun 01 2001 When I use this statement... SELECT CONVERT(varchar,'06/01/2001',101) ...the result is...06/01/2001 The style format for 101 is mm/dd/yy why does SQL ignore my preferred format defined by...- GrocExp
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
