DATETIME FORMATS IN SQL SERVER

HOW TO SET CURRENT DATETIME WITH DIFFERENT DATETIME FORMATS IN SQL SERVER.

Suppose the current date time is :
SELECT GETDATE()  - "2018-11-11 16:53:13.617"

And now we are converting the current date into different formats. These are as belows:

SELECT CONVERT(VARCHAR(10),GETDATE(),101) AS DATE1 = "11/11/2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),102) AS DATE2 = "2018.11.11"
SELECT CONVERT(VARCHAR(10),GETDATE(),103) AS DATE3 = "11/11/2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),104) AS DATE4 = "11.11.2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),105) AS DATE5 = "11-11-2018"
SELECT CONVERT(VARCHAR(11),GETDATE(),106) AS DATE6 = "11 Nov 2018"
SELECT CONVERT(VARCHAR(12),GETDATE(),107) AS DATE7 = "Nov 11, 2018"
SELECT CONVERT(VARCHAR(12),GETDATE(),108) AS DATE8 = "16:53:13"
SELECT CONVERT(VARCHAR(11),GETDATE(),109) AS DATE9 = "Nov 11 2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),110) AS DATE10 = "11-11-2018"
SELECT CONVERT(VARCHAR(10),GETDATE(),111) AS DATE11 = "2018/11/11"
SELECT CONVERT(VARCHAR(10),GETDATE(),112) AS DATE12 = "20181111"
SELECT CONVERT(VARCHAR(11),GETDATE(),113) AS DATE13 = "11 Nov 2018"
SELECT CONVERT(VARCHAR(11),GETDATE(),114) AS DATE14 = "16:53:13:61"

Please see the below screenshot for the clarifications.

  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  - - - - - - - - - - - - - - - - - - - - - - - - Cheers, Happy to Help! - - - - - - - - - - - - - - - - - - - - - - - - - - -