|
|
Archives of the TeradataForum
Message Posted: Thu, 06 Mar 2003 @ 08:55:39 GMT
Subj: | | Re: MSAccess Date Parameter Queries Against Linked TD tables |
|
From: | | Mirjam Berger |
John,
I'm not sure if your problem is related and if it applies to 2.08 already. (I think it does, but I don't have a 2.08 available to
check)
| We have checked the regional date settings and they are identical. We have the same ODBC 2.8.0 settings of Session Mode:
System default and Date Time Format: III. | |
Many of or timestamp operations did not work until we found that we had to set the Date Time format to "AAA" (we run under session mode
Teradata, but this should not be connected.)
There is a drop down for Date time, and it seems like it only has 2 options, but it really has more, you just need to scroll. "AAA" was
the closest thing to a magical bullet we ever found with ODBC, so I thought I let you know about it :)
God Luck!
Mirjam
| |