DaniWeb Forum Index > Web Development > PHP

Time Stamp

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2008

Posts: 74

Reputation: Vai is an unknown quantity at this point

Solved Threads: 5

Vai

Offline

Junior Poster in Training

Time Stamp

Sep 8th, 2009

How do I make the timestamp string be displayed as something that is actually readable / understandable? Yes, I have looked on google, here and a couple other places, but I am not seeing anything too specific or I am just not understand. Thank you for your understanding, helping me out and not being too critical.

Here is what I have:

In the database:
timestamp int(11) unsigned

and it inserts it like this:
1252386167

Using Php to display Last Active it displays it like this:
1252410826

Thank you,

•

Join Date: Apr 2008

Posts: 53

Reputation: SimonMayer is an unknown quantity at this point

Solved Threads: 10

SimonMayer SimonMayer is offline

Offline

Junior Poster in Training

Re: Time Stamp

Sep 8th, 2009

Here is a customised function I use:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
function EpochDate($timestamp, $format = "Y-m-d H:i:s")
{
	$final_timestamp = date($format, mktime(0 , 0, $timestamp, 1, 1, 1970));
	return($final_timestamp);
}
function EpochDate($timestamp, $format = "Y-m-d H:i:s")
{
	$final_timestamp = date($format, mktime(0 , 0, $timestamp, 1, 1, 1970));
	return($final_timestamp);
}