Removing the Date from SQL DateTime

This solution is short and efficient:

CONVERT(VARCHAR(10), GETDATE(), 101)