smalldatetime convert to varchar

[GrocExp]

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 101?

The format Jun 01 2001 is number 107. Does this have anything to do with the definition of time on the SQL Server?

:-I

 

[GrocExp]

I'm replying to my own message. I had a variable defined wrong. I had to change that declaration from varchar to smalldatetime.
LOL