1 Reply Latest reply: Jul 17, 2013 7:30 AM by Yogesh_RAJ RSS

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

    paatel

      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.