![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Thu, 10 May 2001 @ 16:38:46 GMT
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
| |