日期轉換 yyyy/MM/dd → yyyyMMdd (SQL)

(case when EXPRESS_Date is null or rtrim(EXPRESS_Date) = ''

then '' else replace(Convert(Char(10),Convert(DateTime , EXPRESS_Date, 111),111),'/','') end)