Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Seconds to time column conversion
From:   Anomy Anom

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


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020