We help IT Professionals succeed at work.

Formatting MySQL CURRENT_TIMESTAMP value using PHP

IDEASDesign
IDEASDesign asked
on
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
Comment
Watch Question

<?php
$timestamp="2008-01-11 13:43:14";
$newtime=strtotime($timestamp);
echo date("l, F d, Y @ g:i A",$newtime);
?>
You could do something like this, where $timevariable represents your variable containing the timestamp from the database

echo date("l, F d, Y @ g:i A",strtotime($timevariable));

Author

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

I've awarded you the 500pts.

Cheers,
- Yvan

Explore More ContentExplore courses, solutions, and other research materials related to this topic.