Archives of the TeradataForum

Message Posted: Wed, 21 Apr 2004 @ 09:13:47 GMT

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

<-- Anonymously Posted: Wednesday, April 21, 2004 00:16 -->

Hi there,

The following is my question :

How to update a column which is in varchar(20) that contains values in seconds for eg. 9999 to HH:MI:SS format like 2:46:39.

I know of the function CAST((INTERVAL '9999' SECOND) AS INTERVAL HOUR TO SECOND(0)) that is possible to do this job for me but I have two concerns using this :

1. The above code ceases to work if the '9999' is replace with a column name of the table.

2. The range is not good enough, Teradata manual specifies the max number range we can specify as second is 9999. We have numbers over 9999 hence this solution isn't the option.

Any other way to convert the seconds to time format any of you guys know of, it will be lot of help to me.

Cheers

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