Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 16 Jun 2005 @ 17:41:36 GMT

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

Subj:   Re: TDQM timestamps
From:   Anomy Anom

<-- Anonymously Posted: Thursday, June 16, 2005 12:40 -->

Anomy.Anom wrote:

  TDQM has columns named "timestamp" that are defined as integers. Can someone tell me how to convert these to date & time, if that's what they are?  

          > SELECT update_timestamp FROM dbqrymgr.pending_updates order by 1;
          >  *** Query completed. 5 rows found. One column returned.
          >  *** Total elapsed time was 0.17 seconds.

          > update_timestamp
          > ----------------
          >        172911881
          >        172919431
          >        172919662
          >        172919891
          >        174727579

Here is some additional information about my question. We have access logging turned on for user dbqrymgr, and this shows when an insert was done and the timestamp value that was inserted into the table at that time:

     LogDate  05/06/06
     LogTime  07:26:17
        TEXT  INSERT INTO pending_updates(update_timestamp, restrict_name,
     user_name, user_type, obj_type, obj_name, operation) VALUES(174727579,
     'owbsesspl', 'NONE', 'NONE','NONE', 'NONE', 'MOD')

But I'm not able to convert 174727579 to 05/06/06 07:26:17, or anything close to that.

Thanks again,


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