Re: reading timestamp from audit trail files

Kleanthis Goozis wrote: > > Informix's Techinfo document #782 describes the format of > the audit trail header as follows: [SNIP] ww - after update > > 3-6 integer A 4 byte > representation > of the date > and time > (number of > seconds > since Janu- > ary 1 , 1970.) > [SNIP] > 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)? Well, first the *integer* is an Informix *integer*. A C long. THis may be machine dependant. But I digress..... If your trying to use SQL/4GL, just set a date variable = to this. then you can format your output accordingly. The fild is already a date. Hope this helps -Mikey