Re^2: Problem converting with FROM

If i edit this line

 FROM_UNIXTIME(trans_date) AS 'Action_date'
[download]

And instead use just the column name

 SELECT serial_num, trans_date , actor, type, trans_data, content FROM
+ transtable
[download]

The date values are displayed but in unix format.

Comment on Re^2: Problem converting with FROM_UNIXTIME Select or Download Code

Replies are listed 'Best First'.
Re^3: Problem converting with FROM_UNIXTIME by ibra (Novice) on Jun 23, 2011 at 14:22 UTC
Sorry guys yep the problem was the lowercase issue. I complete missed this line `$sth->fetchrow_hashref("NAME_lc")` [download] Thank you rev_1318 for spotting it	[reply] [d/l]