Date/time

[stage]

Hi, I’m trying Ireport now to generate reports.

I don’t have the ultimate manual yet, but I like to now how I convert the Unix date to a read able date. I thought to us the Mysql function “DATE_FORMAT()” but that doesn’t work.

So my question is what (ireport)function can I use to convert de date/time field

[nelsonab]

This link should help
http://dev.mysql.com/doc/refman/5.1/...functions.html

The specific function you are looking for is FROM_UNIXTIME()

[zabbix_zen]

Hi stage.

Considering you're building a fresh iReport integration with Zabbix, would you mind sharing your experiences in a cookbook form in a few weeks?

This is a fairly common issue and would be helpful to Zabbix users with reports generation needs.