How to convert case when condition 6 digit decimal to date format (SQL)

Viewed 27

Would like to convert

Case when ItemAltCd LIKE '%WEBLIVE%'
       then Right(ItemAltCd , Charindex('-',ItemAltCd) -2)
     when ItemAltCd LIKE '%WEBREC%'
       then Right(ItemAltCd , Charindex('-',ItemAltCd) -1)
     else ' '
end as 'Event Date'

Event Date Output like 123120 (MMDDYY)

0 Answers
Related