MySQL Forums
Forum List  »  Newbie

Re: changing date_format
Posted by: nancy vanderjagt
Date: August 04, 2005 01:56PM

I am also a newbie, but I was under the impression that you were only allowed to store the data in the table in the YYYY-MM-DD format, but could reformat it when you took it back out.

SELECT
DATE_FORMAT(eventDate, '%M %e, %Y'),
eventName
FROM events
ORDER BY eventDate

****
However, I'm stuck on this also. I've tried to reformat the date in both mysql and in php. I can get the the MySQL query to return the expected results using phpMyAdmin, but I can't get it to echo through to my php page.

Let me know if I'm doing something wrong.

Options: ReplyQuote


Subject
Written By
Posted
July 21, 2005 10:14AM
Re: changing date_format
August 04, 2005 01:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.