Re: Problem converting with FROM

What output are you getting and what are you expecting?

Besides, I'm not sure, but doesn't $sth->fetchrow_hashref("NAME_lc") mean that ALL fieldnames are in lower case?
So I'm guessing that you want $transaction->{action_date} in stead of $transaction->{'Action_date'}...

Paul

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

Replies are listed 'Best First'.
Re^2: Problem converting with FROM_UNIXTIME by ibra (Novice) on Jun 23, 2011 at 14:16 UTC
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.	[reply] [d/l] [select]
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]