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