[SOLVED]How to load HYYMDS from Oracle to SQL server?

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/7957049496

November 26, 2020, 10:24 AM

nox

[SOLVED]How to load HYYMDS from Oracle to SQL server?

Hi,

I have a field in Oracle with HYYMDS which is DateTime data that I want exact data into SQL Server. But when I using Iway to load this table into SQL server, and I notice that same field become YYMD which is cut off time from HYYMDS, even I change MAS file to HYYMDS, it show " 1990/01/01 00:00:00" which is set all time to 00:00:00.
any idea how to fix this?

This message has been edited. Last edited by: nox,