SELECT CONVERT(DATETIME, '20241009', 112) AS ConvertedDate; SELECT CAST('20241009' AS DATETIME) AS ConvertedDate;