TSQL datetime format

datestring                           style example
------------------------------ ----------- ---------------------------------------------
08/22/12                                 1 SELECT CONVERT(nvarchar(100),getdate(),1)
12.08.22                                 2 SELECT CONVERT(nvarchar(100),getdate(),2)
22/08/12                                 3 SELECT CONVERT(nvarchar(100),getdate(),3)
22.08.12                                 4 SELECT CONVERT(nvarchar(100),getdate(),4)
22-08-12                                 5 SELECT CONVERT(nvarchar(100),getdate(),5)
22 Aug 12                                6 SELECT CONVERT(nvarchar(100),getdate(),6)
Aug 22, 12                               7 SELECT CONVERT(nvarchar(100),getdate(),7)
14:23:00                                 8 SELECT CONVERT(nvarchar(100),getdate(),8)
Aug 22 2012  2:23:00:357PM               9 SELECT CONVERT(nvarchar(100),getdate(),9)
08-22-12                                10 SELECT CONVERT(nvarchar(100),getdate(),10)
12/08/22                                11 SELECT CONVERT(nvarchar(100),getdate(),11)
120822                                  12 SELECT CONVERT(nvarchar(100),getdate(),12)
22 Aug 2012 14:23:00:357                13 SELECT CONVERT(nvarchar(100),getdate(),13)
14:23:00:360                            14 SELECT CONVERT(nvarchar(100),getdate(),14)
2012-08-22 14:23:00                     20 SELECT CONVERT(nvarchar(100),getdate(),20)
2012-08-22 14:23:00.363                 21 SELECT CONVERT(nvarchar(100),getdate(),21)
08/22/12  2:23:00 PM                    22 SELECT CONVERT(nvarchar(100),getdate(),22)
2012-08-22                              23 SELECT CONVERT(nvarchar(100),getdate(),23)
14:23:00                                24 SELECT CONVERT(nvarchar(100),getdate(),24)
2012-08-22 14:23:00.367                 25 SELECT CONVERT(nvarchar(100),getdate(),25)
Aug 22 2012  2:23PM                    100 SELECT CONVERT(nvarchar(100),getdate(),100)
08/22/2012                             101 SELECT CONVERT(nvarchar(100),getdate(),101)
2012.08.22                             102 SELECT CONVERT(nvarchar(100),getdate(),102)
22/08/2012                             103 SELECT CONVERT(nvarchar(100),getdate(),103)
22.08.2012                             104 SELECT CONVERT(nvarchar(100),getdate(),104)
22-08-2012                             105 SELECT CONVERT(nvarchar(100),getdate(),105)
22 Aug 2012                            106 SELECT CONVERT(nvarchar(100),getdate(),106)
Aug 22, 2012                           107 SELECT CONVERT(nvarchar(100),getdate(),107)
14:23:00                               108 SELECT CONVERT(nvarchar(100),getdate(),108)
Aug 22 2012  2:23:00:433PM             109 SELECT CONVERT(nvarchar(100),getdate(),109)
08-22-2012                             110 SELECT CONVERT(nvarchar(100),getdate(),110)
2012/08/22                             111 SELECT CONVERT(nvarchar(100),getdate(),111)
20120822                               112 SELECT CONVERT(nvarchar(100),getdate(),112)
22 Aug 2012 14:23:00:437               113 SELECT CONVERT(nvarchar(100),getdate(),113)
14:23:00:437                           114 SELECT CONVERT(nvarchar(100),getdate(),114)
2012-08-22 14:23:00                    120 SELECT CONVERT(nvarchar(100),getdate(),120)
2012-08-22 14:23:00.440                121 SELECT CONVERT(nvarchar(100),getdate(),121)
2012-08-22T14:23:00.443                126 SELECT CONVERT(nvarchar(100),getdate(),126)
2012-08-22T14:23:00.443                127 SELECT CONVERT(nvarchar(100),getdate(),127)
 5 شوال 1433  2:23:00:447PM            130 SELECT CONVERT(nvarchar(100),getdate(),130)
 5/10/1433  2:23:00:447PM              131 SELECT CONVERT(nvarchar(100),getdate(),131)