Hi akhter,
The error Conversion failed when converting date and/or time from character string is due to below possible reason.
Date accept YYYY-MM-dd format.
Some record might be exceeded the Month and Date value.
i.e. Month value greater than 12 or Date value greater that max value of the specified month
Example :
2020-13-12 - Month value is 13.
2020-02-30 - Date is 30 which doesn't belongs to Month 02 (Feb)
So please verify the posibilities.
Rest query is correct.
SQL
CREATE TABLE #Containerno (CID INT,RID INT,DID INT,Entrydate DATE)
INSERT INTO #Containerno VALUES(1,101,1,'2019-07-01')
INSERT INTO #Containerno VALUES(2,101,1,'2019-07-02')
INSERT INTO #Containerno VALUES(3,101,1,'2019-07-03')
INSERT INTO #Containerno VALUES(4,101,1,'2019-07-04')
INSERT INTO #Containerno VALUES(5,101,1,'2020-02-12')
INSERT INTO #Containerno VALUES(6,101,1,'2020-02-12')
INSERT INTO #Containerno VALUES(7,101,1,'2020-02-12')
SELECT CID,RID,DID,CONVERT(VARCHAR,Entrydate,103) AS EntryDate
FROM #Containerno
DROP TABLE #Containerno
Output
CID RID DID EntryDate
1 101 1 01/07/2019
2 101 1 02/07/2019
3 101 1 03/07/2019
4 101 1 04/07/2019
5 101 1 12/02/2020
6 101 1 12/02/2020
7 101 1 12/02/2020
