Re: Date Concat?

From:	Rick Widmer	Date:	Fri, 20 Sep 2002 22:46:11 +0000
Subject:	Re: Date Concat?
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-21881@lists.php.net to get a copy of this message

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