 |
 |
Archives of the TeradataForum
Message Posted: Thu, 15 Mar 2012 @ 20:25:40 GMT
| Subj: | | Re: Logon time interpretation |
| |
| From: | | Dieter Noeth |
JAMES PARK wrote:
| | Whenever I see logontime column of some tables it appears this way and I can't figure out the time. How can I interpret this? | |
It's a float which holds a time using hhmiss, logontime was added before there was a TIME datatype. It has a FORMAT '99:99:99.99', when you
cast it to a CHAR(11), at least it looks like a TIME :-)
> LogonTime
> 105,624.31 -> 10:56:24.31
Dieter
| |
