1 Reply Latest reply on Jul 17, 2013 12:30 PM by Yogesh_RAJ

    Extra zero is comming when extacting Date field from oracle to text file


      Hi ,


      I am extracting the data from Oracle to Flat file.For the date fileds I am finding extra zero at the end( 2010-07-12 00:00:00.0 ), any questions why it is displaying extra zero?.


      And I would like get all the date fileds in the format of  'YYYYMMDDHHMMSS'  , can set this rule at topoly level or at data model rather than having to_date function for each data field?


      Thanks and Regards,

      Durgareddy Katta.