convert value of 'connected' from syssessions

Posted in 1997

"Peter Wang" — 29 Apr 1997 04:48:31 -0400 — source: Informix-list mailing list archive (1991-1998)

Hi all, Has anyone tried to convert the value of column 'connected' in table = syssessions (sysmaster database) into more meaningful date time format in = a SQL statement? For example: 862295401 -> 1997-04-29 15:33:42 (something like that) (It seems that the integer value represents seconds from 1970-01-01 = 00:00:00) Any tips are appreciated. Cheers. Peter