Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2003 @ 08:55:39 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: MSAccess Date Parameter Queries Against Linked TD tables
From:   Mirjam Berger


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!


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020