how to remove time in Sql

In the SQL Server, Here is multiple options for removing time from datetime column. We can use CONVERT or CAST function by converting the datetime to date type only.

For Example

DECLARE @CurrentDate DateTime = GetDate()
SELECT @CurrentDate As CurrentDateTime

--OptionNo.1
SELECT CONVERT(DATE,@CurrentDate) AS OptionNo.1

--OptionNo.2
SELECT CAST(@CurrentDate AS DATE) AS OptionNo.2

--OptionNo.3
SELECT CONVERT(char(10), @CurrentDate,126) AS OptionNo.3

Hello ,

Please Try This 

SELECT CONVERT(nvarchar,  convert(date, '11/12/2023 10:11:00 pm', 101), 101) As DateFormat

date format is correctly displaying in excel but date is not proper

SELECT CONVERT(date, MyDate) AS MyDateOnly
FROM MyTable

Hello Meghana, 
Try to use select convert(nvarchar, "your date column name ", 103)

BENCHAABAN Ali