convert day month and year to date sql server

Question

plz i have day in varchar and month and year also in varchar how convert it in date in sql server

Kashif Asif · Answer

have a look at it you can convert all these columns using concatenation SELECT convert ( date , CONVERT (nvarchar(10), t. year ) + '-' + CONVERT (nvarchar(10), t. month ) + '-' + CONVERT (nvarchar(10), t. day )) as 'Date' from Table_1 t;

Shubham Kule · Answer

string day = "10" ; string month = "6" ; string year = "2018" ; DateTime ab = Convert.ToDateTime(day+ "-" + month+ "-" + year); label1.Text = ab.ToString();

Aditya manthankar · Answer

Hello, Look at the below query, It may help you. For SQL Server 2008+: SELECT CONVERT(DATE,CAST([Year] AS VARCHAR(4))+'-'+ CAST([Month] AS VARCHAR(2))+'-'+ CAST([Day] AS VARCHAR(2))) For SQL Server 2005: SELECT CONVERT(DATETIME,CAST([Year] AS VARCHAR(4))+ RIGHT('00'+CAST([Month] AS VARCHAR(2)),2)+ RIGHT('00'+CAST([Day] AS VARCHAR(2)),2))

malak laghoz · Answer

Kashif Asif,you can send me a message in my email malak.laghoz@gmail.com pour que je t'envois capture d'ecran de l'erreur que j'aurai

Monis Azhar · Answer

Check this out. It may help you. https://stackoverflow.com/questions/1509977/convert-varchar-into-datetime-in-sql-server

convert day month and year to date sql server

Answers (5)