Archives of the TeradataForum

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

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

<-- 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>>