you can add [any] formatting you wish inside the ' ' hth jeff David Shugarts <Azimuth@Compu To: <php-db@lists.php.net> Serve.com> cc: Subject: Re: date formatting... help 05/16/2003 09:34 AM While we are on this subject, does anyone know how to force a comma or two in there, as in: Friday, September 5, 2003 TIA --Dave Shugarts > > right on > $query_rsViewNews = "SELECT newsId, newsAuthor, newsTitle, > DATE_FORMAT(newsDate, '%M %e, %Y') AS Fdate, newsDate, newsDescription FROM > news ORDER BY newsDate DESC"; > > makes sense.. > thanks > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php