Friday 25 May 2012

Difference between CAST and CONVERT functions


Cast and convert functions are used to convert one data type to another datatype, but CAST is ANSI standard function and CONVERT is specific to MSSQL Server and by using CONVERT we can get the specified format particularly for datetime datatype fields.

Reference : MSDN_CAST_CONVERT


Performance wise both the functions will perform equally.

Reference : Good Post

No comments:

Post a Comment