I wish to give a certain format to the mySQL DATE (2000-05-23) (Year-Month-Day). Does anybody knows how to give this DATE the following format 23-05-2000 (Day-Month-Year)?
Use the MySQL function: date_format(date,format)
It would look something like this: date_format(column, '%e-%c-%Y')
