DBA THINGS

Tag: cast and convert

  • Series : Versus

    Series : Versus

      Our Versus Series is a comparsion series of blogs. Here, we will try to compare one concept with another or one feature with another. SN Date Topic  1  04 Jun 2015  CAST vs. CONVERT      

  • 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…