Hi,
I am using teradata API to read the date columns in datastage 8 server edition . When I am viewing the data it is showing the date column value in the datastage internal format. I trying casting the date to char and then change the datatype to char in the column definition. But no good.
Pleas suggest I can I see the actual date instead of internal value.
reading date column from teradata API stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Fri Oct 21, 2005 4:09 am
reading date column from teradata API stage
Thanks and Regards
Abha
Abha
-
- Participant
- Posts: 37
- Joined: Fri Oct 21, 2005 4:09 am
Re: reading date column from teradata API stage
Thankyou Chuett,
That is also giving me error, but I have used the OCONV function to get the date in the readable format and it has solved my problem
That is also giving me error, but I have used the OCONV function to get the date in the readable format and it has solved my problem
Thanks and Regards
Abha
Abha
-
- Participant
- Posts: 37
- Joined: Fri Oct 21, 2005 4:09 am