PHP mySQL and Date

[Anon]

Hello,

I am pulling a date out of a mySQL database and comparing it to todays date. The date comes out in the format yyyy-mm-dd and I would like to just print out the mm-dd using PHP. What is the easiest way to do this?

Thanks
Sean Wilhelm

[toma42]

use the mysql function unix_timestamp()

[jburfield]

Why not just pull the date out in that format?

select date_format(date_field, "%c-%e") as date ...etc

That way you do not have to convert it using php once it's pulled from the database, it comes out that way.

-- Jason