Re: DATE_FORMAT

From:	user at domain dot invalid	Date:	Wed, 26 Jun 2002 04:30:19 +0000
Subject:	Re: DATE_FORMAT
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-20123@lists.php.net to get a copy of this message

Applause and ovations to the PHP Crew ! Russ wrote:

Seth: Sure you can have 400 if you wanted! ;-) $sql = "SELECT DATE_FORMAT(Date01, '%M %d %Y') AS date01, DATE_FORMAT(Date02, '%M %d %Y') AS date02
			    FROM Events
			    WHERE Event_ID = '$Event_ID'
"); Take it easy. Russ -----Original Message----- From: Seth Yount [mailto:sethyount@cox.net] Sent: Wednesday, June 26, 2002 6:17 AM To: php-db@lists.php.net Subject: [PHP-DB] DATE_FORMAT 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. I would rather not use another query just to get another colum. -- Seth