Hi all,
I am reading a date field using oracle enterprise stage,
No default type conversion from type "timestamp" to type "date".
i have used Orchestrate table definition import to import metadata from database table but it is converting date to timestamp.
if i keep timestamp then i am able to view data, but not with date datatype.
Regards,
DSinghal
unbale to view data from oracle stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Tue Jan 29, 2008 6:03 am
- Location: Guntur
- Contact:
What needs to done when loading??
Hi ArndW,ArndW wrote:Oracle DATEs are actually timestamps, so keep the timestamp definition. ...
I faced the same problem. So, I have taken it as timestamp. But when loading this data into another oracle table, what needs to be done to load the data as it is into a date field??? Thanks in advance.
Samratisking
Re: What needs to done when loading??
keep it as timestamp in DS