Format PHP Date

[JamesNZ]

I save dates to the database in the following format - "1979-12-28"

When displaying them on the website I want to display it as "28 Dec 1979" so I tried this:

echo "Born:" . date("d M Y",$myrow["DOB"]) . "<br>";

but that converts "1979-12-28" to "Born:31 Dec 1969"

What am I doing wrong?

[visualAd]

Are you using MySql? Databases often store dates in a different format. In MySql can convert the date in your database to a UNIX timestamp inside your query:

SELECT FROM table UNIX_TIMESTAMP(date) date;


Once this is done you can use it in the date function.

[JamesNZ]

Thanks for your response. I'd rather keep it stored in my MYSQL database in date format for ease of use.

Isn't there anyway to convert "1979-12-28" to "28 Dec 1979"?

[visualAd]

Its still going to be stored in date format. You will be converting it to the format PHP understands inside the SELECT query, it won't change the format in which the data is stored in your database.

Post your query and I'll show you what I mean if you still don't follow.

[Phenix]

Yes, the timestamp argument "$myrow["DOB"]" is in the wrong format.
string date ( string format [, int timestamp] )

Try:
echo "Born:" . date("d M Y",mktime(0, 0, 0, substr($myrow["DOB"],5,2), substr($myrow["DOB"],8,2), substr($myrow["DOB"],0,4))) . "<br>";

Edit: Actually, changing the query may be cleaner, but you'll need say an alias like UNIX_TIMESTAMP(Your_DOB_column) AS DOB_AsTimeStamp and use $myrow["DOB_AsTimeStamp"]
echo "Born:" . date("d M Y",$myrow["DOB_AsTimeStamp"]) . "<br>";

[JamesNZ]

Thanks Phenix.

Used:

<b>Born: </b> <?php echo date("d M Y",mktime(0, 0, 0, substr($DOB,5,2), substr($DOB,8,2), substr($DOB,0,4))); ?> <br>

and it worked a treat.

Thanks for your help also visualAd :)

[McCain]

You could try the strtotime() (http://www.php.net/manual/en/function.strtotime.php) function.

It would look something like this:
echo 'Born: ' . date('d M Y',strtotime($myrow['DOB'])) . '<br />';

[visualAd]

Thanks Phenix.

Used:

<b>Born: </b> <?php echo date("d M Y",mktime(0, 0, 0, substr($DOB,5,2), substr($DOB,8,2), substr($DOB,0,4))); ?> <br>

and it worked a treat.

Thanks for your help also visualAd :) James,

Most databases store dates in a different format, all these databases have the functions requied to convert form their native date types to unix timestamps.

Its all very well using the solution posted by Penix, but it will be both slower and will break should MySql one day decide to change thier date format or you need to use another database, it will break. So what at first, looks good and easy to use, in the long run it will probably give you a headache.

[JamesNZ]

James,

Most databases store dates in a different format, all these databases have the functions requied to convert form their native date types to unix timestamps.

Its all very well using the solution posted by Penix, but it will be both slower and will break should MySql one day decide to change thier date format or you need to use another database, it will break. So what at first, looks good and easy to use, in the long run it will probably give you a headache.

What solution would you suggest visualAd?

[McCain]

I think this is what he is suggesting:

Are you using MySql? Databases often store dates in a different format. In MySql can convert the date in your database to a UNIX timestamp inside your query:

SELECT FROM table UNIX_TIMESTAMP(date) date;


Once this is done you can use it in the date function.

[visualAd]

What solution would you suggest visualAd? The one I posted which involves doing the conversion inside the SELECT query using the UNIX_TIMESTAMP() function. This will be quicker and more efficient than using PHP's string manipulation functions and make your code mroe portable.

[r_amin]

I need It, But from 2005 This problem not solved !!!!!!!!!!
How can I show a date in the format of 11/12/2007 from database?

[penagate]

Start your own thread for your own questions please.