Convert date from dd-mm-yyyy to yyyy-mm-dd in SQL Server

Question

Given date:

DECLARE @Date1 VARCHAR(50) = '30-01-2015'

I want to convert it into the 2015-01-30.

Answer 1

Try this:

DECLARE @Date1 VARCHAR(50) = '30-01-2015'

SELECT CONVERT(VARCHAR(10), CONVERT(date, @Date1, 105), 23) 

I hope this helps you.

Answer 2

Enter date format