Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 18 Jun 2002 @ 19:59:15 GMT

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

Subj:   Re: Microsoft-Access and Teradata
From:   Margaret Westlake

We also had trouble with Access deciding that our date math should be performed on the PC and not on the Teradata. This resulted in problems with returning 30 times the data you intended to the PC. Our date math was intended to return only YYYYMM instead of the full date. Then it seemed that the date math didn't function as expected in Access on the returned data resulting in incorrect groupings. I think that we fixed it by using SUBSTR on the date (not as efficient, but Access didn't try to do it and let Teradata handle it). This was several years ago and I haven't tested it since to see if it works right now. I gave up on using Access when I ran into these problems. (Btw Fred, our missing date for admissions is 1777-07-07 and Excel and Access don't like it either.)

  <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