SQL yyyyymmdd CAST to date

CAST(CAST(yyyymmdd AS char(8)) AS date)

SQL
AD
味方出版