Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Nov 2001 @ 17:33:09 GMT


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


Subj:   Horizontal CASE Reporting
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, November 20, 2001 11:17 -->

I am attempting to produce a frequency table with a range of seconds on the horizontal (0 to 1 secs, 1 to 3 secs and so on)

The following (element) works OK: (timeon is an interval HOUR(2) to SECOND(2) datatype)

SUM(CASE AAA.timeon
       WHEN (INTERVAL '00:00:01.00' HOUR to SECOND)
            THEN  1
            ELSE NULL
     END)    AS  Secs_0_to_1

However any attempt I have tried to utilize a range of seconds has failed. I do not see an example like this in any of the NCR and Terra-Tom manuals that I have

One example is:

SUM(CASE AAA.timeon
       WHENtimeon>=  (INTERVAL '00:00:01.00' HOUR to SECOND)
     and timeon <=   (INTERVAL '00:00:01.00' HOUR to SECOND)
            THEN  1
            ELSE NULL
     END)    AS  Secs_0_to_1

Is there a way around this problem?

Thanks.



     
  <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