Archives of the TeradataForum

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

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

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

Anomy.Anom wrote:

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

Anomy

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