Lpad Equivalent Of Oracle In Db2

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • techiesekar07
    New Member
    • Mar 2007
    • 3
    #1

    Lpad Equivalent Of Oracle In Db2

    this is an oracle query SUBSTR(LPAD(xxx xx, 8, 0),3,6)

    Please provide me the db2 query for this....
    Tags: None
    • frozenmist
      Recognized Expert New Member
      • May 2007
      • 179
      #2
      Originally posted by techiesekar07
      this is an oracle query SUBSTR(LPAD(xxx xx, 8, 0),3,6)

      Please provide me the db2 query for this....
      REPEAT('0',6-LENGTH(RTRIM(CA ST(xxxxx AS CHAR(6)))))||RT RIM(CAST(xxxxx AS CHAR(6)))

        Comment

        • frozenmist
          Recognized Expert New Member
          • May 2007
          • 179
          #3
          You can also try this

          right('000000'| |rtrim(cast(<nu mber> as char(6))),6)

          This looks good right....

          Cheers,
          Rahul

            Comment

            Previous template Next
            Working...