For HH:MM Am/pm
SELECT LTRIM(Right(REPLACE(CONVERT(nvarchar(MAX),CAST(GetDate() as smalldatetime), 109),':00:000', ' '), 8))as[current_time]For HH:MM:SS Am/pm
select CONVERT(VARCHAR(8), getdate(), 108) + ' ' + RIGHT(CONVERT(VARCHAR(30), getdate(), 9), 2)