> I have a table where I save the date. The format is "2005-07-19" in my > table. I want to change the format to "19-07-2005" when on the screen for > the user. What is the best way to reformat the date?
You may go with DATE_FORMAT(date,format) - lookup the manual for date and time functions: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html or you can use php do the job with date() http://php.net/date HTH Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
