Hi Peter,
It resolved the timestamp issue but I am still getting more characters in
timestamp. I only need to get maximum of 23 characters. any suggetsions on
how to trim this data from 2021-02-02 09:01:24.847756 to 2021-02-02
09:01:24.8 ? I have yyy-MM-dd hh:mm:ss.S in timestamp field for
Thanks Peter, this worked. I have now issue with csv reader and loading
that into SQL server. Will send out seperate email for that.
On Tue, Mar 2, 2021 at 9:37 AM Peter Turcsanyi wrote:
> Hi Asmath,
>
> If I understand your flow correctly, you have ExecuteSQLRecord
> (or
Hi Asmath,
If I understand your flow correctly, you have ExecuteSQLRecord
(or QueryDatabaseTableRecord) with CSVRecordSetWriter and the expected
output format for Oracle DATE type would be DD-MM- in the CSV.
To achieve this, you'll need to configure CSVRecordSetWriter's "Timestamp
Format"
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,
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
wrote:
> Hi,
>
> I
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