Archives of the TeradataForum
Message Posted: Wed, 21 Apr 2004 @ 09:13:47 GMT
<-- Anonymously Posted: Wednesday, April 21, 2004 00:16 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|