Hi all,

What are the differences between CAST and CONVERT functions in SQL statement specially for SQLSERVER ?

Thanks in advance

John

CAST is based on the SQL-92 standard and is preferred over CONVERT

Jaime E. Maccou
Applications Analyst

SELECT CONVERT(char(8),GETDATE(),112)

In the above example CONVERT() offers superior functionality to CAST(),CONVERT ()supports a style parameter (the third argument above) that specifies the exact format to use when converting a datetime value to a character string.