Page 1 of 1

Convert MySQL date to Month and Day

Posted: Sat Mar 01, 2003 12:12 am
by crimius
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

Posted: Sat Mar 01, 2003 12:21 am
by Jade

Posted: Sat Mar 01, 2003 2:20 am
by hob_goblin
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

Posted: Sat Mar 01, 2003 11:24 am
by crimius
Thanks yall!

Posted: Sat Mar 01, 2003 1:57 pm
by twigletmac
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