[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5123
  • Last Modified:

Formatting MySQL CURRENT_TIMESTAMP value using PHP

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
0
IDEASDesign
Asked:
IDEASDesign
  • 2
1 Solution
 
darron_chapmanCommented:
<?php
$timestamp="2008-01-11 13:43:14";
$newtime=strtotime($timestamp);
echo date("l, F d, Y @ g:i A",$newtime);
?>
0
 
darron_chapmanCommented:
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));
0
 
IDEASDesignAuthor Commented:
Thanks Darron!  Incorporating the strtotime() function seemed to do the trick.

I've awarded you the 500pts.

Cheers,
- Yvan
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now