CAST and CONVERT - TechNet - Microsoft

Is the style of date format used to convert datetime or smalldatetime data to .... SQL Server also returns an error when an empty string (" ") is converted to numeric ...

technet.microsoft.com