Tag: convert syntax

  • CAST vs. CONVERT

    CAST vs. CONVERT

    Datatype conversion is a common scenario that we face while writing SQL queries. Cast and Convert are two functions provided by SQL for this purpose. But what is the difference between the two? CAST and CONVERT provide similar functonality. CAST is according to ANSI standards and has a simpler syntax. CONVERT on the other hand…