select ISNULL(REPLACE(REPLACE(RIGHT('0'+LTRIM(RIGHT(CONVERT(Nvarchar,GETDATE(),100),7)),7),'AM',''),'PM',''),'')
SELECT LTRIM(RIGHT(CONVERT(VARCHAR(20), GETDATE(), 100), 7))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)