Archives of the TeradataForum

Message Posted: Thu, 13 Jul 2006 @ 13:24:48 GMT

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

I get the same results:

     select z.ts01 - interval '0.000001' second   from flavio1 z;
      *** Query completed. One row found. One column returned.
                     (ts01- 0.000001)
     --------------------------------
     2000-12-30 23:59:59.999999+00:00

     select z.ts01 - interval '00:00.000001' minute to second   from flavio1 z;
      *** Failure 7451 Invalid timestamp.
                     Statement# 1, Info =0

     select z.ts01 - interval '00:00:00.000001' hour to second   from flavio1 z;
      *** Failure 7451 Invalid timestamp.

This looks like a bug, although there could be some obscure ANSI rule that prohibits these expressions. I suggest you open an incident with the GSC.

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