DSXchange

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.

That's not "DataStage internal format". What happens if you simply change the data type of that column in the job, with no "casting"? Try Varchar or Timestamp rather than Date. Experiment.

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

It would help future searchers if you posted the specifics of how you used OConv in this context for Teradata date fields. That way there's more than one person that knows how to do this.

Thanks for the suggestion. I did the following.
While reading the DateField I did Oconv(DateField ,"D/MDY") in the derivation in transformer stage.