[PHP-DB] mysql time format

[David Chamberlin]

Hey,

This is a bit of a newbie question, but I couldn't find what I wanted in the documentation.

Is there any way to set the time format so that any time values in my SELECT call are in a speicified format (e.g., HH:MM instead of HH:MM:SS).

Basically I've got a table of a variety of different types, some of which are times. I want to issue a select that retrieves all of the data for a row, and have any time values be returned in HH:MM (for example).

I can (very painfully) go through all the results, figure out which ones are time values, and then do SELECT TIME_FORMAT() on each one of those, but that seems like a horrendous solution to a simple problem.

Any help?

Thanks,
Dave


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php