What is the differences between Cast and Convert functions in SQL Server with T-SQL?

Question

Possible Duplicate:
T-SQL Cast versus Convert

score 4 · Accepted Answer · answered Jan 11 '11 at 20:55

4

Convert is a SQL server only function and Cast is more generic(can be used in other dbms). Convert provides more flexability than Cast. So if you are trying to choose which one to use, I would suggest Cast uness you have a specific reason to use Convert. As a suggestion;
Dates, times : Convert
Decimals, numerics : Cast

answered Jan 11 '11 at 20:55

Steve

133
5

thanks you very much .ı know that information but ı confused – cetin Jan 11 '11 at 21:20

What is the differences between Cast and Convert functions in SQL Server with T-SQL?

1 Answers1