Both cast and covert serves the same purpose i.e. convert a data type to another.
- Cast
- Cast is ANSII Standard
- Cast cannot be used for Formatting Purposes.
- Cast cannot convert a datetime to specific format
- Convert
- Convert is Specific to SQL SERVER
- Convert can be used for Formatting Purposes.For example Select convert (varchar, datetime, 101)
- Convert can be used to convert a datetime to specific format
examples:
select convert(varchar(20),getdate(),101)
o/p:10/25/2012
select cast('100abcd' as varchar(20))
o/p:101abcd
No comments:
Post a Comment