Re: changing date_format
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.
Subject
Written By
Posted
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.