GETDATE() Function in SQL Server

SELECT GETDATE()'ONLY GETDATE'                  --    2014-08-20 12:27:37.663

SELECT CAST(GETDATE() AS VARCHAR(20))'CAST'     --    Aug 20 2014 12:27PM

SELECT CONVERT(VARCHAR,GETDATE())'CONVERT'      --    Aug 20 2014 12:27PM

SELECT CONVERT(VARCHAR,GETDATE(),0)'0'          --    Aug 20 2014 12:27PM

SELECT CONVERT(VARCHAR,GETDATE(),1)'1'          --    08/20/14

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

SELECT CONVERT(VARCHAR,GETDATE(),3)'3'          --    20/08/14

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

SELECT CONVERT(VARCHAR,GETDATE(),5)'5'          --    20-08-14

SELECT CONVERT(VARCHAR,GETDATE(),6)'6'          --    20 Aug 14

SELECT CONVERT(VARCHAR,GETDATE(),7)'7'          --    Aug 20, 14

SELECT CONVERT(VARCHAR,GETDATE(),8)'8'          --    12:27:37

SELECT CONVERT(VARCHAR,GETDATE(),9)'9'          --    Aug 20 2014 12:27:37:663PM

SELECT CONVERT(VARCHAR,GETDATE(),10)'10'        --    08-20-14

SELECT CONVERT(VARCHAR,GETDATE(),11)'11'        --    14/08/20

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

SELECT CONVERT(VARCHAR,GETDATE(),13)'13'        --    20 Aug 2014 12:27:37:663

SELECT CONVERT(VARCHAR,GETDATE(),14)'14'        --    12:27:37:663

SELECT CONVERT(VARCHAR,GETDATE(),100)'100'      --    Aug 20 2014 12:27PM

SELECT CONVERT(VARCHAR,GETDATE(),101)'101'      --    08/20/2014

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

SELECT CONVERT(VARCHAR,GETDATE(),103)'103'      --    20/08/2014

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

SELECT CONVERT(VARCHAR,GETDATE(),105)'105'      --    20-08-2014

SELECT CONVERT(VARCHAR,GETDATE(),106)'106'      --    20 Aug 2014

SELECT CONVERT(VARCHAR,GETDATE(),107)'107'      --    Aug 20, 2014

SELECT CONVERT(VARCHAR,GETDATE(),108)'108'      --    12:27:37

SELECT CONVERT(VARCHAR,GETDATE(),109)'109'      --    Aug 20 2014 12:27:37:663PM

SELECT CONVERT(VARCHAR,GETDATE(),110)'110'      --    08-20-2014

SELECT CONVERT(VARCHAR,GETDATE(),111)'111'      --    2014/08/20

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

SELECT CONVERT(VARCHAR,GETDATE(),113)'113'      --    20 Aug 2014 12:27:37:663

SELECT CONVERT(VARCHAR,GETDATE(),114)'114'      --    12:27:37:663

SELECT CONVERT(VARCHAR,GETDATE(),120)'120'      --    2014-08-20 12:27:37

SELECT CONVERT(VARCHAR,GETDATE(),121)'121'      --    2014-08-20 12:27:37.663

SELECT CONVERT(VARCHAR,GETDATE(),126)'126'      --    2014-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

Current Date using Case:-

SELECT CASE WHEN DATEPART(DD,GETDATE()) IN (1,21,31) THEN DATENAME(D,GETDATE()) + 'st ' + DATENAME(MONTH,GETDATE()) + ' ' + DATENAME(YEAR,GETDATE())

            WHEN DATEPART(DD,GETDATE()) IN (2,22) THEN DATENAME(D,GETDATE()) + 'nd ' + DATENAME(MONTH,GETDATE()) + ' ' + DATENAME(YEAR,GETDATE())

            WHEN DATEPART(DD,GETDATE()) IN (3,23) THEN DATENAME(D,GETDATE()) + 'rd ' + DATENAME(MONTH,GETDATE()) + ' ' + DATENAME(YEAR,GETDATE())

            ELSE DATENAME(D,GETDATE()) + 'th ' + DATENAME(MONTH,GETDATE())+ ' ' + DATENAME(YEAR,GETDATE()) END