RE: date formatting... help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



i think you're use of " instead of ' is what is giving you errors.

hth
jeff


                                                                                                                    
                    "Paul Ihrig"                                                                                    
                    <pihrig@columb       To:     <php-db@lists.php.net>                                             
                    us.rr.com>           cc:                                                                        
                                         Subject:     RE:  date formatting... help                          
                    05/16/2003                                                                                      
                    09:22 AM                                                                                        
                                                                                                                    
                                                                                                                    




Jeffery
like this?

$query_rsViewNews = "SELECT newsId, newsAuthor, newsTitle,
DATE_FORMAT("newsDate", "%M %e, %Y") AS Fdate, newsDate, newsDescription
FROM news ORDER BY newsDate DESC";

which throughs errors..


--
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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux