Our Training Programs

All contents are copyright of their authors.

convert day month and year to date sql server

convert day month and year to date sql server

malak laghoz

8yAsked Jul 3, 2018, 4:20 AM1.9k.NET

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

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

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))

Kashif Asif,you can send me a message in my email [email protected] pour que je t'envois capture d'ecran de l'erreur que j'aurai

Check this out. It may help you.

https://stackoverflow.com/questions/1509977/convert-varchar-into-datetime-in-sql-server

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;