At 07:07 AM 9/20/02 -0500, Rankin, Randy wrote: > SELECT > DATE_FORMAT(start_date, '%M %d, %Y') as start_date, > DATE_FORMAT(end_date, '%M %d, %Y') as end_date > FROM training > >This produces the following: > > start_date: September 16, 2002 > end_date: Sepetember 20, 2001 > >Based on the above, I would like to echo out something like this: > > You will be in training September 16 - 20, 2002.
SELECT CONCAT( DATE_FORMAT(start_date, '%M %d' ), ' - ', DATE_FORMAT( end_date, '%d, %Y' )) AS dates, ... Rick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php