Converting a CYYMMDD date in SQL

Turning the seven-digit format into a real date with a single expression.