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

Reply via email to