UNIXTIME Conversion in iReport

[scott1714]

Hi -

MySQL, iReport 3.5

I have been Gogoling and searching this forum all day trying to convert unixtime into something ledgible for users.

I have tried FROM_UNIXTIME but the field is integer so it returns only 2009 for all dates.

Trying to format this using DATE_FORMAT(date, '%M %e, %Y, %l:%i%p') etc... but this pulls an error of "Cannot Cast from Interger to String". I also tried various nestings of CONVERT and CAST.

I am new to iReport and any assistance with this would be most welcome.

Kind regards,

Scott

 

 

 

 

[scott1714]

New here...looks like I put this in the wrong forum.

 

I changed the field descriptor to "java.lang.String" and then used:

 

Cast(date_format(FROM_UNIXTIME(date), '%Y-%m-%d') as CHAR) AS date to get what I needed.

 

Please move or delete.

 

Kind regards,

Scott