Date Time Format in SQL Server 2008

SELECT GETDATE()

2013-08-20 12:27:37.663

SELECT CAST ( GETDATE() AS VARCHAR(20))

Aug 20 2013 12:27PM

SELECT CONVERT(VARCHAR,GETDATE())

Aug 20 2013 12:27PM

SELECT CONVERT(VARCHAR,GETDATE(),0)'0'

Aug 20 2013 12:27PM

SELECT CONVERT(VARCHAR,GETDATE(),1)'1'

08/20/13

SELECT CONVERT(VARCHAR,GETDATE(),2)'2'

13.08.20

SELECT CONVERT(VARCHAR,GETDATE(),3)'3'

20/08/13

SELECT CONVERT(VARCHAR,GETDATE(),4)'4'

20.08.13

SELECT CONVERT(VARCHAR,GETDATE(),5)'5'

20-08-13

SELECT CONVERT(VARCHAR,GETDATE(),6)'6'

20 Aug 13

SELECT CONVERT(VARCHAR,GETDATE(),7)'7'

Aug 20, 13

SELECT CONVERT(VARCHAR,GETDATE(),8)'8'

12:27:37

SELECT CONVERT(VARCHAR,GETDATE(),9)'9'

Aug 20 2013 12:27:37:663PM

SELECT CONVERT(VARCHAR,GETDATE(),10)'10'

08-20-13

SELECT CONVERT(VARCHAR,GETDATE(),11)'11'

13/08/20

SELECT CONVERT(VARCHAR,GETDATE(),12)'12'

130820

SELECT CONVERT(VARCHAR,GETDATE(),13)'13'

20 Aug 2013 12:27:37:663

SELECT CONVERT(VARCHAR,GETDATE(),14)'14'

12:27:37:663

SELECT CONVERT(VARCHAR,GETDATE(),100)'100'

Aug 20 2013 12:27PM

SELECT CONVERT(VARCHAR,GETDATE(),101)'101'

08/20/2013

SELECT CONVERT(VARCHAR,GETDATE(),102)'102'

2013.08.20

SELECT CONVERT(VARCHAR,GETDATE(),103)'103'

20/08/2013

SELECT CONVERT(VARCHAR,GETDATE(),104)'104'

20.08.2013

SELECT CONVERT(VARCHAR,GETDATE(),105)'105'

20-08-2013

SELECT CONVERT(VARCHAR,GETDATE(),106)'106'

20 Aug 2013

SELECT CONVERT(VARCHAR,GETDATE(),107)'107'

Aug 20, 2013

SELECT CONVERT(VARCHAR,GETDATE(),108)'108'

12:27:37

SELECT CONVERT(VARCHAR,GETDATE(),109)'109'

Aug 20 2013 12:27:37:663PM

SELECT CONVERT(VARCHAR,GETDATE(),110)'110'

08-20-2013

SELECT CONVERT(VARCHAR,GETDATE(),111)'111'

2013/08/20

SELECT CONVERT(VARCHAR,GETDATE(),112)'112'

20130820

SELECT CONVERT(VARCHAR,GETDATE(),113)'113'

20 Aug 2013 12:27:37:663

SELECT CONVERT(VARCHAR,GETDATE(),114)'114'

12:27:37:663

SELECT CONVERT(VARCHAR,GETDATE(),120)'120'

2013-08-20 12:27:37

SELECT CONVERT(VARCHAR,GETDATE(),121)'121'

2013-08-20 12:27:37.663

SELECT CONVERT(VARCHAR,GETDATE(),126)'126'

2013-08-20T12:27:37.663

SELECT CONVERT(VARCHAR,GETDATE(),130)'130'

14 ???? 1434 12:27:37:663PM

SELECT CONVERT(VARCHAR,GETDATE(),131)'131'

14/10/1434 12:27:37:663PM