Hi,
Use this;
SELECT CONVERT(VARCHAR(26), GETDATE(), 109)
SELECT CONVERT(VARCHAR(24), GETDATE(), 113)
SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)]
SELECT CONVERT(VARCHAR(19), GETDATE(), 120)
SELECT CONVERT(VARCHAR(23), GETDATE(), 121)
SELECT CONVERT(VARCHAR(23), GETDATE(), 126)
SELECT CONVERT(VARCHAR(26), GETDATE(), 130)
SELECT CONVERT(VARCHAR(25), GETDATE(), 131)