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
