Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 May 2001 @ 16:38:46 GMT


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


Subj:   Time based arithmetic
 
From:   Gordon Richardson

I have two time-based questions:

1) Most, if not all the time, time-based info in DBC (e.g. logontime in DBC.eventlog) is stored as floating point numbers with formats like (99:99:99.99). What is the most convenient/easiest method to convert this to Time format so that, for example, one can do arithmetic calculations that treats this info as times and not just floating point numbers? What is the best way to convert this real number to a time data type?

2) The DBC.eventlog stores logon time. At what point in the logon process is this time obtained? I am assuming it is only after the logon has been successful. Also, when there is a logoff, at what point is the time obtained?


Thanks.

Gordon Richardson



     
  <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: 27 Dec 2016