display date readable

[aebstract]

I have a unix timestamp such as: 1200435437

I need to convert this in to something like  m/d/Y  with the date function, how can I go about doing this?

Thanks!

[AndyB]

http://www.plus2net.com/php_tutorial/php_date_time.php

[discomatt]

check out date()

 

echo date('m/d/Y', $stamp);

[aebstract]

$date_created_readable = date('m/d/Y', $date_created);

echo "$date_created_readable";

 

That is what I have, but it is just displaying: 01/15/2008 for every value, but every row in the db has a different value for date_created.

[AndyB]

That is what I have, but it is just displaying: 01/15/2008 for every value, but every row in the db has a different value for date_created.

 

Then there's a problem with how you're retrieving the data. show us some more complete code

[aebstract]

$result = mysql_query("SELECT * FROM albums ORDER BY id ASC") or DIE(mysql_error());
while($r=mysql_fetch_array($result))
{

$id=$r["id"];
$superid=$r["superid"];
$date_created=$r["date_created"];
$date_modified=$r["date_modified"];
$title=$r["title"];
$bg_color=$r["bg_color"];

echo "<li><a href=\"index.php?page=edit&edit=$superid\">edit</a> | <a href=\"index.php?page=album&album=$superid\">$title</a></li>";
$date_created_readable = date('m/d/Y', $date_created);
echo "$date_created_readable";

}

 

and when I echo the date_created, it displays a unique timestamp for each result..

[PFMaBiSmAd]

If they were all created on the same date, but at different times, you would get the same output from the code. If you add the time to the format string, the example number in the first post is actually - 01/15/2008 15:17:17

[discomatt]

If we could see some sample timestamps in your DB we could help debug your issue a little faster.

[aebstract]

It works, the difference in time is actually in seconds. Sorry for the confusion and thanks for the help.

[discomatt]

Yes, it appears most are on the same day.

 

<?php

$str = '1200594207
1200435878
1200435906
1200435913
1200435925
1200435930';

foreach (explode("\n", $str) as $stamp)
echo date ('m/d/Y h:i:s', $stamp) . '<br>';

?>

 

Returns

 

01/17/2008 10:23:27
01/15/2008 02:24:38
01/15/2008 02:25:06
01/15/2008 02:25:13
01/15/2008 02:25:25
01/15/2008 02:25:30