This is the Solution what i got for updating the time part of the date time column
DROP TABLE TestTable
CREATE TABLE TestTable(
ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
FirstName NVARCHAR (50) NULL,
Testdate datetime NULL
)
Truncate TABLE TestTable
INSERT INTO TestTable VALUES ('Tejas',GETDATE())
INSERT INTO TestTable VALUES ('Ankit',GETDATE())
INSERT INTO TestTable VALUES ('Jayesh',GETDATE())
INSERT INTO TestTable VALUES ('Chirag',GETDATE())
INSERT INTO TestTable VALUES ('Sagar',GETDATE())
INSERT INTO TestTable VALUES ('Ronak',GETDATE())
INSERT INTO TestTable VALUES ('Jayesh',GETDATE())
INSERT INTO TestTable VALUES ('Ashish',GETDATE())
INSERT INTO TestTable VALUES ('Rumit',GETDATE())
INSERT INTO TestTable VALUES ('Vijiyant',GETDATE())
SELECT * FROM TestTable
DECLARE @ID INT;
DECLARE @ROW INT;
SET @ROW = (SELECT COUNT(1) FROM TestTable)
SET @ID = 0
WHILE (@ID < @ROW)
BEGIN
SET @ID += 1;
UPDATE TestTable SET Testdate = (select CONVERT(datetime, convert(varchar(10),(SELECT Testdate FROM TestTable WHERE ID = @ID) ,101)) ) WHERE ID = @ID
END
SELECT * FROM TestTable