Query to Convert VARCHAR to DATETime and add months in SQL Server

Hi smile,

Refer below sample query.

SQL

DECLARE @Test AS TABLE(UserID VARCHAR(10),Pass VARCHAR(50),SDate VARCHAR(10))
INSERT INTO @Test VALUES('abc','sky@abc','19.10.2018')
INSERT INTO @Test VALUES('sky','abc@sky','21.10.2018')
SELECT UserID,Pass,SDate,CONVERT(VARCHAR, DATEADD(MONTH,1,CONVERT(DATETIME, SDate, 103)), 104) NextDate FROM @Test

Output