How to parse string into date? January 22, 2023 by Tarik CONVERT(datetime, '24.04.2012', 104) Should do the trick. See here for more info: CAST and CONVERT (Transact-SQL)