Question and Answer Database FAQ4384B.txt — BatchMove of Time field from Paradox to Oracle results in timestamp in the year 3000. Category :Database (Oracle) Platform :All Windows Product :All-CBuilder, BC++4.5x, BC++5.x, C++Builder1.0, C++Builder3.x, C++Builder4.x, Delphi2.x, Delphi3.x, Delphi4.x, 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. 3/26/99 10:30:37 AM
Last Modified: 01-SEP-99