Re: DATE_FORMAT

From:	Bogdan Stancescu	Date:	Wed, 26 Jun 2002 01:43:23 +0000
Subject:	Re: DATE_FORMAT
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-20118@lists.php.net to get a copy of this message

Seth Yount wrote:

Hello all...
    does anyone know if you can select more than one colemn when using the DATE_FORMAT command...
$sdate_query = mysql_query("SELECT DATE_FORMAT(StartDate, '%M %d %Y')
                FROM Events
                WHERE Event_ID = '$Event_ID'
               ");
... Could I have another ColumnName after StartDate such as EndDate. I get an error when I try but I haven't been trying to hard to find a way to do this.

Obviously. $sdate_query = mysql_query("SELECT DATE_FORMAT(StartDate, '%M %d %Y'), DATE_FORMAT(EndDate, '%M %d %Y')

               FROM Events
               WHERE Event_ID = '$Event_ID'
              ");

Bogdan