I have a field that I want to convert to a format of YYYYMMDD and going with this scenario, it gives me a date of '04/18/19'
Declare @MemberDOB nvarchar(10)
Set @MemberDOB = '04/18/1960'
Select Convert(VarChar(8), @MemberDOB, 112)
I want it to be '19600418', but it doesn't. (table uses nvarchar, and cannot be changed to another datatype initially)