What�s the format of time field of Audit Files?

I know that format of Audit Files contains a field than means the date and time a operatin was made. This values is a INTEGER. How can I do to get DATE & TIME in regular format. Thanks. Giovanni M'zquita gio@uxmal.itmerida.mx

Giovanni Mezquita wrote: > > I know that format of Audit Files contains a field > than means the date and time a operatin was made. > > This values is a INTEGER. > How can I do to get DATE & TIME in regular format. AFAIK, the time is a standard Unix time stamp, the number of seconds since 1970-01-01 00:00:00 UTC. In SQL, the way to convert this is: DATETIME(1970-01-01 00:00:00) + timestamp UNITS SECONDS I'm not sure if that will start causing problems in September 2001 when this timestamp overflows into the 10th digit (and, it might be September 2000 rather than 2001). I'm mildly concerned because the largest interval that is permitted is INTERVAL(999999999) SECOND(9) TO SECOND ...I guess I need to check...sometime... -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>