mySQL table questions

[tjbezek1]

I'm trying to build a report from zabbix collected data. I'm capturing
processor load at 30 minute intervals, and want to create a spreadsheet
I can email.

I'm looking in the 'history' table for the item_id for the host_id I want. My questions are, how do I get a user friendly date/time from the 'clock' field, and why does the 'value' 9517839 appear repeatedly, along with 0, 1, and 4? The actual processor load values are in decimal format, such as 6.023

Thanks,

Tim

[Alexei]

What are you talking about? There is no hostid in table history.

See http://www.zabbix.com/manual_internals_db.php for more details.