Archives of the TeradataForum

Message Posted: Fri, 01 Oct 2004 @ 22:15:09 GMT

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

<-- Anonymously Posted: Friday, October 01, 2004 18:10 -->

Hi Forum,

I'm new at Teradata and i'm trying to add two time columns.

I tried to do so but i got the next results:

     Column1       Column2      Result
     23:58:43      0:02:29      23:60:72
     23:58:39      0:01:06      23:59:45
     23:57:56      0:00:33      23:57:89
     23:57:14      0:00:38      23:57:52
     23:57:03      0:00:25      23:57:28
     23:56:44      0:00:28      23:56:72

As you can see, only sometimes the result is good.

I'll appreciate the help you could give me.

Thanks

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