Dont totally agree with this as the following will error which is as I expect because the style is not vailid

-- Just to 100% prove the style is invalid

SELECT DateAsCharacter = CONVERT(VARCHAR(25),GETDATE(),25510)

Msg 281, Level 16, State 1, Line 1

25510 is not a valid style number when converting from datetime to a character string.

But the following seems to want to ignore the style arguement.

SELECT[DateAsDate AM] = CONVERT(DATETIME,'Mar 26 2013 02:49AM' )

SELECT[DateAsDate PM] = CONVERT(DATETIME,'Mar 26 2013 02:49PM' )

SELECT[DateAsDate mm-dd-yy] = CONVERT(DATETIME,'Mar 26 2013 02:49PM' , 110 )

SELECT[DateAsDate yyyymmdd] = CONVERT(DATETIME,'Mar 26 2013 02:49PM' , 112 )

SELECT[DateAsDate No Such format] = CONVERT(DATETIME,'Mar 26 2013 02:49PM' ,25510) -- invalid style so Error? or Ignore?

DateAsDate AM = 2013-03-26 02:49:00.000

DateAsDate PM = 2013-03-26 14:49:00.000

DateAsDate mm-dd-yy = 2013-03-26 14:49:00.000

DateAsDate yyyymmdd = 2013-03-26 14:49:00.000

DateAsDate No Such format = 2013-03-26 14:49:00.000