If you want to remove a time from datetime in TSQL, you have multiple options to do that. You can use CONVERT or CAST function by converting the datetime to date type only.
Here are the 3 options you can use.
DECLARE @CurrentDate DateTime = GetDate() SELECT @CurrentDate As CurrentDateTime --OPTION 1 SELECT CONVERT(DATE,@CurrentDate) AS Option1 --OPTION 2 SELECT CAST(@CurrentDate AS DATE) AS Option2 --OPTION 3 SELECT CONVERT(char(10), @CurrentDate,126) AS Option3