<div>
&lt;?php<br />
$timestamp=&quot;2008-01-11 13:43:14&quot;;<br />
$newtime=strtotime($timest<wbr />amp);<br />
echo date(&quot;l, F d, Y @ g:i A&quot;,$newtime);<br />
?&gt;
</div>


<?php
$timestamp="2008-01-11 13:43:14";
$newtime=strtotime($timestamp);
echo date("l, F d, Y @ g:i A",$newtime);
?>

<div>
Thanks Darron! &nbsp;Incorporating the strtotime() function seemed to do the trick.<br />
<br />
I've awarded you the 500pts.<br />
<br />
Cheers,<br />
- Yvan
</div>


Thanks Darron!  Incorporating the strtotime() function seemed to do the trick.

I've awarded you the 500pts.

Cheers,
- Yvan

<div>
<div class="content wysiwyg-content">
I'm retrieving a &quot;last login&quot; date from a column in a MySQL database which has the &quot;CURRENT_TIMESTAMP&quot; function attached to it. &nbsp;The dates in this column are stored in the following format:<br />
<br />
2008-01-11 13:43:14<br />
<br />
I can't figure out for the life of me how to format this date/time object (using PHP) so that it's more easily readable. &nbsp;It seems that every time I try to wrap a date function around it, that I'm always returning the totally wrong date and time. &nbsp;Every timestamp that I try to convert gets' converted to December 1st, 1969. &nbsp; <br />
<br />
How would I convert a date such as &quot;2008-01-11 13:43:14&quot; to something like ...<br />
<br />
&nbsp;&quot;Friday, January 11, 2008 @ 1:43 PM&quot;<br />
<br />
(using PHP)<br />
<br />
Thanks in advance!<br />
- Yvan
</div>
</div>


I'm retrieving a "last login" date from a column in a MySQL database which has the "CURRENT_TIMESTAMP" function attached to it.  The dates in this column are stored in the following format:

2008-01-11 13:43:14

I can't figure out for the life of me how to format this date/time object (using PHP) so that it's more easily readable.  It seems that every time I try to wrap a date function around it, that I'm always returning the totally wrong date and time.  Every timestamp that I try to convert gets' converted to December 1st, 1969.   

How would I convert a date such as "2008-01-11 13:43:14" to something like ...

 "Friday, January 11, 2008 @ 1:43 PM"

(using PHP)

Thanks in advance!
- Yvan

Formatting MySQL CURRENT_TIMESTAMP value using PHP

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.