This is a bit of a newbie question, but I couldn't find what I wanted in
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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php