Archives of the TeradataForum
Message Posted: Thu, 10 May 2001 @ 16:38:46 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|