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





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