Teradata API Stage - DLL teradata.so, Version 1.2.4.
DATE fields are ANSIDATE FORMAT yyyy-mm-dd.
We routinely change the Table definition metadata of any DATE field to CHAR(10) because this appears to be the only way to handle a date field via the Teradata API stage. Can be this true or are we missing something?
The teradata.pdf makes no mention of the DATE datatype being unsupported.
Is there some method that would preserve the metadata of the DATE field?
Does Teradata API Stage Support Datatype - DATE
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
-
- Charter Member
- Posts: 47
- Joined: Fri Mar 18, 2005 5:59 am
Re: Does Teradata API Stage Support Datatype - DATE
We have faced similar problem whilst reading from TD API stage with date as datatype works erratically, hence char(10) is the safest option.