sql server Delete by date code example

Example 1: REMOVE DATE FROM DATE TIME SQL SERVER

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

SELECT CONVERT(VARCHAR(5),[DATE COLUMN],108) AS TIME