reading timestamp from audit trail files
Posted in 1996
Informix's Techinfo document #782 describes the format of the audit trail header as follows: Byte Data Type Values stored ----------------------------------------------------------------------- 1 -2 character aa - for added records length 2 dd - for deleted records rr - before update ww - after update 3-6 integer A 4 byte representation of the date and time (number of seconds since Janu- ary 1 , 1970.) 7-8 smallint process id 9-10 smallint userid 11 -14 integer isam record number ----------------------------------------------------------------------- Any ideas of how to translate (using SQL) the timestamp (bytes 3-6) to a human readable format (something like mm/dd/yy mm:ss)? TIA Klean