mysql time format
| From: | David Chamberlin | Date: | Tue, 07 Jan 2003 01:24:32 +0000 |
| Subject: | mysql time format | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24608@lists.php.net to get a copy of this message | ||
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