damned date again

nelsons

Have a mysql DB - and an trying to pull a readable date from it. Its an import from an access thing. So I set th type on the field to date:

Seems simple enough right?

The date (just echoing the row) displays on the page as such:

2005-08-18 00:00:00

The date whenI look into the db is mm/dd/yyyy

I have been going mad trying to figure a way or a function to wrap this into a
February 14, 2004 display.

Everything I have tried thus far has failed to display the way I need it too.

Anything helpful appreciated. PHP 4.3/mysql 3.4 or so

Thanks

Sayian

Have you looked into php's date() functions i assume? Nothing their that can help you?

toplay

I don't know how long the DATE_FORMAT() SQL function has been available, but that's the one to use. See manual page:

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html#id2750749

And here's an example I did for someone else:
http://www.phpbuilder.com/board/showpost.php?p=10655186&postcount=5

hth.

zcketcher

date('F jS, Y', strtotime('2005-08-18 00:00:00'));
 // Or..when getting values from a databse..
 date('F jS, Y', strtotime($dbDate));

(I always apreciate an example..especially when it's easy to provide)

You may want to check out MySQL's date functions as well and have it returned to you in the format you want rather than doing the conversion after the fact: MySQL's Date Time Functions

Example: SELECT DATE_FORMAT(your_date_column, '%M %D, %Y') ....

Also, follow Sayian's advice and do a little research on PHP's date() function.