Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Mar 2003 @ 19:56:11 GMT


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


Subj:   Re: Timestamp difference
 
From:   Chuck McDevitt

If I remember from the old days, minute() is a function supported by the ODBC driver.

In the long-ago-past (first ODBC driver for Teradata), minute(x) just got re-written as (x(INTEGER)/100 MOD 100

This definition worked for the old way of having TIME values as numerics with format '99:99:99.99', but of course would not work for interval datatypes, which didn't yet exist.

I assume somewhere along the way, NCR has updated the way minute() works in ODBC, but perhaps they failed to test all the possible ways it would be used with Intervals. I'd avoid using this function, and stick to what is actually in the SQL language.



     
  <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: 27 Dec 2016