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