SQL Convert dd/mm/yy to yymmdd

Question

I have been trying to achieve this all day, I have followed numerous tutorials and can't seem to crack it, I have been trying things like:

select CONVERT(VARCHAR(10), DATE, 131) from Table

yet it does not seem to change anything.

Any advice or help would be appreciated. Thankyou in advance.

Answer 1

SELECT CONVERT(VARCHAR(10), DATE, 12)

12 is the right code for the format you want. See: https://msdn.microsoft.com/en-GB/library/ms187928.aspx

Answer 2

Try this

declare @TDATE Date = '2015-11-10';
select Convert(varchar,Datepart(Year, @TDATE))+Convert(varchar,Datepart(Month, @TDATE))+Convert(varchar,Datepart(Day, @TDATE))

Output:

20151110