Conversion is just a SQL server function, and Cast is more general (can be used in other dbms). Convert provides more flexibility than Cast. Therefore, if you are trying to choose which one to use, I would suggest that you have a specific reason to use Convert. As a suggestion,
Dates, time: Convert
Decimals, number: cast
Steve source
share