date printing format

kingdm

Hello good evening.

I fetch a value on the database, it is a date, it is stored in the database in this format "2009-12-25". I don't have any problem in that, the problem occurs when I try to echo it. When I echo it, it retains its format. I want to have it print in this format, "December 25, 2009".

Can anyone suggests?

cahva

Good afternoon 🙂 (its 2:30 pm here in finland)

This can be done in various ways. If you are on PHP5 server, this is one way:

$dt = new DateTime($r['datefield_from_db']);

echo $dt->format('F d,Y');

Or if you want to use PHP 4 compatible format(works ofcourse in PHP5 too):

echo date('F d,Y',strtotime($r['datefield_from_db']));

Read the manual and check [man]date[/man] for other options to format the date.

NogDog

Or use the DBMS's date formatting function in the query itself to get the desired format.

Weedpacket

kingdm wrote:
it is stored in the database in this format "2009-12-25".

Strictly speaking, it probably isn't but instead in some form more amenable to arithmetic; yyyy-mm-dd would just be the (international standard) formatting that's applied to make it human-readable. As NogDog says, you can tell the DBMS to use a different format.