Extract Only the Time from datetime

Select substring(convert(nvarchar(10),getdate(),108),1,5)

Leave a comment