I need to covert a varchar column represneting dates based on format to date in SQL Server. I have tried below but it gives me an error. The format of varchar date column is as below
YYYY-mm-dd
Select CONVERT(date, '1403-02-17', 103)
Msg 241, Level 16, State 1, Line 171
Conversion failed when converting date and/or time from character string.
Completion time: 2024-05-28T09:08:06.1989389+03:30