Fix issue with convert function when converting string to date, datetimeoffset, datetime2, datetime, smalldatetime or time

Fix issue with convert function when converting string to date, datetimeoffset, datetime2, datetime, smalldatetime or time #10830