How to convert integer to datetime (SMI)

Posted in 1998

partha@fcmc.com — Wed, 28 Jan 1998 13:48:12 -0600 — source: Informix-list mailing list archive (1991-1998)

There are certain fields in the SMI tables which have an integer column that represents a time (i.e. syssessions.connected). How do I convert this to the real date & time? Partha Dutta partha@fcmc.com