Simple date ? concerning MySQL

[PHPslide]

If you have a MySQL database field-type of "date" how do you bring the date to the web in the manner of say... "December 1, 2003" ?

As you probably know when you submit a date into the date field-type it has to be yyyy-mm-dd.

I don't want to display the date this way. I would rather "December 1, 2003".

I know of one way I have done it before which is exploding the date by the "-" sign and then assigning variables etc. But is there an easier way? I would think PHP would have built in modules for this type of thing?

Maybe I can do it right in a SQL query?

If anyone knows of anything, PLEASE, tell me. 🙂

[mcrbids]

Well, I dunno about MySQL's ability to render a date. Typically, I ignore the "date" field type, and store dates an a *nix epoch. (integer, very easy!)

Try these two PHP functions:

StrToTime()

Date()

I wish you luck.

[Hafkas]

MySQL also has a function named date_format http://www.mysql.com/doc/en/Date_and_time_functions.html that allows you to format the date however you like.