Thank you all
mysql Date format change
Moderator: General Moderators
-
Arsench2000
- Forum Commoner
- Posts: 38
- Joined: Sat Sep 15, 2007 8:18 pm
mysql Date format change
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
Thank you all
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England
Re: mysql Date format change
Code: Select all
SELECT DATE_FORMAT(NOW(), '%d/%m/%Y')-
Arsench2000
- Forum Commoner
- Posts: 38
- Joined: Sat Sep 15, 2007 8:18 pm
Re: mysql Date format change
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