 |
 |
Archives of the TeradataForum
Message Posted: Fri, 06 Jun 2014 @ 15:58:22 GMT
| Subj: | | Re: How to get complete SQL by Combining DBQLSQLTBL and DBQLOGTBL |
| |
| From: | | Geoffrey Rommel |
After creating the table, run SHOW TABLE on it. If you created the table from an ODBC session, you will probably find that Col3 is not defined
as TIMESTAMP(6) but as something else.
To fix this problem, edit your ODBC data source to use option 'AAA' for the Date/Time/Timestamp types or, better yet, connect with Teradata.Net
rather than ODBC.
| |
