convert timestamp into date

[Anon]

is there a way to convert a timestamp in a table into a date? I'm sure I could go through and write a long program to do that but I don't think that Is at all efficant is there an EZer way?
TIA
Travis Harris

[gigowiz]

Is this a Unix timestamp? Check out the date function at http://www.php.net/manual/en/function.date.php

Hank

[whizkid]

Hi,

this should work:

function timestamp2unix($date) {
$std = $date[11].$date[12];
$min = $date[14].$date[15];
$sek = $date[17].$date[18];
$mon = $date[5].$date[6];
$tag = $date[8].$date[9];
$jhr = $date[0].$date[1].$date[2].$date[3];
$time = mktime($std,$min,$sek,$mon,$tag,$jhr);

return $time;
}

echo timestamp2unix("2002-01-01 12:00:00"); //Returns 1009882800

The function returns the Unix timestamp, that you can format with the date() function.

firemouse2001