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 <mdkhajaasm...@gmail.com> 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 >