CAST vs CONVERT

CAST function In SQL :-

CAST(expression AS data_type)

CONVERT function In SQL :-

CONVERT(data_type[(length)], expression [, style])

Both CAST and CONVERT are much same..

CONVERT is T-SQL specific, it supports style in case of date-time conversions.

CAST is ANSI specific. ANSI-SQL is more portable across database platforms.