I have retreived a date from a MySQL database such as 1993-06-01.
I want to take that value and convert it with PHP to: June, 1993.
I am sure this is simple but am having trouble finding the right function.
Thanks in advance,
-Craig
Convert MySQL date to Month and Day
Moderator: General Moderators
- hob_goblin
- Forum Regular
- Posts: 978
- Joined: Sun Apr 28, 2002 9:53 pm
- Contact:
Read the date function part of the manual, and also check out how i helped here:
http://www.devnetwork.net/forums/viewtopic.php?t=6728
http://www.devnetwork.net/forums/viewtopic.php?t=6728
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
MySQL can also do this (and it'll save PHP having to do the work). Check out the DATE_FORMAT() function:
http://www.mysql.com/doc/en/Date_and_ti ... tions.html
Mac
http://www.mysql.com/doc/en/Date_and_ti ... tions.html
Mac