RE: [PHP-DB] DATE_FORMAT
| From: | Russ | Date: | Wed, 26 Jun 2002 02:12:27 +0000 |
| Subject: | RE: [PHP-DB] DATE_FORMAT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20120@lists.php.net to get a copy of this message | ||
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php