Главная страница | назад





Article #19384: BatchMove of Time field from Paradox to Oracle results in timestamp in the year 3000.

 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