I have a field called: news_date in a my sql db... it is a "datetime" thing, and it stores the date in this format 0000-00-00 00:00:00 .. how can I display the date in other formats? eg. the day and the month ?
See:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#id2964176
There's lots of MySQL date and time functions. Example:
SELECT DATE_FORMAT(news_date, '%d %M') AS news_date_frmt FROM table_name
The above displays just the day and name of month. If you want numeric month use a lowercase 'm' as in %m. Just check out the link I gave.
