4 Replies Latest reply: Jun 7, 2012 3:01 AM by Jason Michaelides RSS

    Year changes into a numeric field during extraction

      Hi all,

       

      i'm connecting to an oracle database.

      The years im extracting (eg. 2007, 2008, 2009) are into a column with num(20,0). So no decimals,

      Im extracting through an OLE DB connection.

       

      When I get output, the years are represented as a number (eg 2007,00; 2008,00;2009,00).

       

      Is there a setting in the connection or something to let the values just 2007 etc?

       

      Thanks in advance.

       

      KR

      Reyman