Page 1 of 1

mysql Date format change

Posted: Tue Sep 23, 2008 1:48 pm
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

Re: mysql Date format change

Posted: Tue Sep 23, 2008 2:06 pm
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.

Re: mysql Date format change

Posted: Tue Sep 23, 2008 2:38 pm
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