mysql Date format change

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Arsench2000
Forum Commoner
Posts: 38
Joined: Sat Sep 15, 2007 8:18 pm

mysql Date format change

Post by Arsench2000 »

Hello experts, please can you help me to change the date format in mysql :((( its like a 0000-00-00 but I want to bea dd/mm/yyyy

Thank you all
User avatar
jayshields
DevNet Resident
Posts: 1912
Joined: Mon Aug 22, 2005 12:11 pm
Location: Leeds/Manchester, England

Re: mysql Date format change

Post by jayshields »

Code: Select all

SELECT DATE_FORMAT(NOW(), '%d/%m/%Y')
Google could have told you that in about 2 seconds. Please search before posting in future.
Arsench2000
Forum Commoner
Posts: 38
Joined: Sat Sep 15, 2007 8:18 pm

Re: mysql Date format change

Post by Arsench2000 »

thanks, but please if you can help, so help Ive poted here to receive the help correctly in the google are many but different.Thank you again, but I think that I can post here too
Post Reply