6 Replies Latest reply on Oct 14, 2015 8:19 AM by Ken Mouning

    Help converting Character to Number in Universe of DB2 database

    Ken Mouning
    Visibility: Open to anyone

      I have a year field that is stored as Character in DB2.  I'm trying to change the format to number in my universe so that I can join it to another number field in a different universe.  I've tried using the Decimal function and Double function, but neither of those work.  Is there some type of to_number function that I can use in the universe to convert this field to a number?