Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 28 Oct 2002 @ 20:31:00 GMT


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


Subj:   A question about intervals
 
From:   Joan Robertson

I have an interval value that contains 3 20:16 which = 3 days, 20 hours and 16 minutes

I can pull out the hour and minutes and would like to pull the day, but when I try to extract the Day portion I receive an error.

5407 Invalid operation on an ANSI datetime or Interval value.

,extract(hour from diff_time) returns 20
,extract(minute from diff_time) return 16

Has anyone done this. In reading the documentation it seems I should be able to do this.


Thanks

Joan



     
  <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