Mega Code Archive

 

Categories / Delphi / ADO Database

 

Batchmove of time field from paradox to oracle results in timestamp in the year 3000

Question: How come when I batch move my Paradox table to my Oracle table I have timestamp data in the year 3000. Answer: This can occur when you batchmove time fields. Oracle does not have an exact match, so a timestamp field is created. Oracle has no Time field, so an arbitrary date is put into the DATE field with the original time.