Hi Peter, This issue is occuring for the DATE field on oracle. There are other fields which are timestampe in oracle for the same table.
Sample Data in Oracle: Date Field type --> 01-NOV-20 May I know the field name and format that I need to use in csvrecordwriter now? Thanks, Asmath On Mon, Mar 1, 2021 at 12:20 PM Peter Turcsanyi <[email protected]> wrote: > Hi Asmath, > > I would try to specify the format in the Timestamp Format property. > Oracle's DATE type can contain HH:mm:ss part and I believe it is converted > to a Timestamp and the Timestamp Format is applied. > > Regards, > Peter > > On Mon, Mar 1, 2021 at 6:42 PM KhajaAsmath Mohammed < > [email protected]> wrote: > >> Hi, >> >> I have an issue where the csvrecordwriter is automatically converting >> data from date to number. how to resolve this? >> >> any suggestions to change this? >> >> [image: image.png] >> >> Source : Oracle with Date format >> >> [image: image.png] >> >> Target: Sql-server into Date format >> >> >> Thanks, >> Asmath >> >
