Home Forums SQL Server 7,2000 T-SQL what is the difference between CAST and CONVERT Function? RE: what is the difference between CAST and CONVERT Function?

  • EdVassie (4/22/2008)


    Apart from the datetime formatting capabilities of CONVERT, CAST and CONVERT do identical jobs.

    Not quite true.

    Conversions of float, real, money, or smallmoney to character data types also use styles.

    Check BOL fo details.

    _____________
    Code for TallyGenerator