Archives of the TeradataForum
Message Posted: Wed, 12 Nov 2008 @ 15:11:29 GMT
| Subj: || || Re: Adding timestamp column via Alter statement with SQL Assistant |
| From: || || Diehl, Robert |
You also want to look at your ODBC date time and timestamp settings. Click on the OPTIONS button on the lower right hand side of the ODBC
driver setup page for the connection you are using. On the new window change DATETIMEFORMAT to your desired settings. I recommend AAA which is
ANSI for DATE, TIME and Timestamp. You can use this instead of what Mike recommends below.