Re: [phplib] value returned by $db->f From: Bob Bowker (bowker <email protected>)
Date: 05/05/01

Hi --

You've nested things incorrectly ... try
    DATE_FORMAT($db->f('field_containing_timestamp'),"%d-%c-%Y %T")

Good luck!

Bob.

At 10:00 PM 5/5/01 +0200, you wrote:
>Has anyone a workaround for this:
>
>I'm using DB_sql class and function 'f'' like
>$db->f('field_containing_timestamp').
>The function returns the value of the database field as expected.
>Now this:
>$db->f('DATE_FORMAT(field_containing_timestamp, "%d-%c-%Y %T")')
>I was hoping some nicely formatted output, however, nothing returns,
>despite the fact that the SQL statement parsed correctly.
> (Using qualifiers like $db->f('tablename.field_containing_timestamp') do
> not return a result either.
>
>Any ideas are welcome,
>
>Cheers,
>Peter
>
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: phplib-unsubscribe <email protected>
>For additional commands, e-mail: phplib-help <email protected>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>