Converting Integer(TimeDate) to UTC Time Date - MySQL

[belaie]

Novell Identity Manager 3.5.1
Windows Sever 2003 R2
Novell Audit 2.0.2 + MySQL 5.0x


We are logging all our IDM driver events to the naudit database in mySQL.

We want to write our own reporting application which will directly query the Naudit Database for events within specifc date/times.

But when looking directory into the naudit.naudit table, so we can see the there integer values that exists in the columns "ClientTimestamp" and "ServerTimestamp".

Does anyone have formula to convert all these integer values to the Human readable dates and times on the fly ???.. .

For Examples, We are intrested to specify Queries which will lookup for the events between Start-Date (ClientTimestamp) and EndDates(ClientTimestamp).

How would we do this from SQL stuff? ... or any other tips??

Here some examples of the cryptic integer value that we see in the columsn


1222267171
1222266790
etc




Regards,

Maqsood.