plugin_thold_log table

[JSchuricht]

I am attempting to integrate thold into our existing in house messaging system. To do this I need to dump data into another data base. It appears that thold is storing all the alerts in the plugin_thold_log table. Two things are confusing me, what format is the time column in? I would like to extract the current date and time but I have no idea what 1372558128 translates into. The second thing may not be important, the description column has many blanks. I am guessing this is just the trigger event with no important data to display?

[phalek]

That number represents the unix timestamp:

http://www.onlineconversion.com/unix_time.htm

you can convert it directly from a mysql query with:

Code: Select all

SELECT FROM_UNIXTIME(timestring)

Look here for some examples: http://www.epochconverter.com/programmi ... ixtime.php

[JSchuricht]

Thank you, it was driving me nuts trying to find a formula for it.