mysql time format

From: 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

« previous php.db (#24608) next »