Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Sep 2007 @ 15:49:45 GMT


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


Subj:   Re: ODBC TIMESTAMP math problem (datatype - or ANSI Date Time error)
 
From:   Richard Terry

Scenario:

When math is done on TIMESTAMP data i.e.(TIMESTAMP - TIMESTAMP = result), you get and error . Query assistant and ODBC handle this error, include it in the reply and then give you the data you requested.

Business Objects does not give you the return because it traps the return error and stops right there, responding with "Unsupported Datatype", because the returned value is an interval datatype. The near term answer is to cast the entire answer set to char(22) to get rid of the error and allow for all positions in the interval that might have data.

So the working, if simplistic Query (for Business Objects) is:

     select cast(tmstp - tmstp day(4) to second(6)) as char(22))
     from view_db sample 10

The longer term answer for Business Objects would be to accommodate the datatype natively, and is probably a bug fix in some patch version.

We worked this out with our Teradata guys here. Thanks to Bill for the heavy lifting.

Thanks for all your help in the forum


Richard Terry



     
  <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: 15 Jun 2023