Sybase Data Type,Control File Mapping,Oracle Target Data Type,Precision Loss Notes
datetime,"TIMESTAMP ""YYYY-MM-DD HH24:MI:SS.FF3"" NULLIF event_datetime=BLANKS",TIMESTAMP(3),No loss; preserves ~3.33 ms precision
datetimn,"TIMESTAMP ""YYYY-MM-DD HH24:MI:SS.FF7"" NULLIF event_datetimn=BLANKS",TIMESTAMP(7),Minimal loss; retains up to 100 ns if exported with 7 decimals
bigdatetime,"TIMESTAMP ""YYYY-MM-DD HH24:MI:SS.FF9"" NULLIF event_bigdatetime=BLANKS",TIMESTAMP(9),No significant loss; supports up to 100 ns and extended range (0001-9999)
Top comments (0)