CODE EXAMPLE FOR SQL

REMOVE DATE FROM DATE TIME SQL SERVER

SELECT CONVERT(varchar(8), GETDATE(), 108) AS TimeOnly
CONVERT(VARCHAR(7),@AppDate,111) date year only