INFORMIX-SE:
SE allows you to create an audit file for any table. The audit file has the same schema as the table being audited plus a header consisting of several columns, one of them being a_time INTEGER, which contains a UNIX timestamp of when the row was added, updated or deleted. UNIX timestamp is an INTEGER value corresponding to the number of seconds since 1970-01-01T00:00:00Z. Can anyone come up with an algorithm which can accurately convert these seconds into a date and time?