CONVERT(nvarchar(20), [Date],101) as 'Date'    10/20/2016

CONVERT(nvarchar(20), [Date],102) as 'Date'    2016.10.20

CONVERT(nvarchar(20), [Date],103) as 'Date'    20/10/2016

CONVERT(nvarchar(20), [Date],104) as 'Date'    20.10.2016

CONVERT(nvarchar(20), [Date],105) as 'Date'    20-10-2016

CONVERT(nvarchar(20), [Date],106) as 'Date'    20 Oct 2016

CONVERT(nvarchar(20), [Date],107) as 'Date'    Oct 20, 2016

CONVERT(nvarchar(20), [Date],108) as 'Date'    13:31:54

CONVERT(nvarchar(20), [Date],109) as 'Date'    Oct 20 2016  1:31:54

CONVERT(nvarchar(20), [Date],110) as 'Date'    10-20-2016

CONVERT(nvarchar(20), [Date],111) as 'Date'     2016/10/20