MySQL timestamp to desired date function
| From: | Cesar Aracena | Date: | Thu, 18 Sep 2003 04:38:50 +0000 |
| Subject: | MySQL timestamp to desired date function | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-162950@lists.php.net to get a copy of this message | ||
Hi all,
I have a a timestamp in a DB (14 digits) that I want to display like I
want in my pages. I tried to use strtotime, mktime and date functions
with no success... it always return the current timestamp instead of the
one I have stored. This is what I've done so far:
for ($x = 0; $x < $num_rows; $x++)
{
$row = mysql_fetch_array($result);
$date1 = strtotime($row[lugar_lastinsert]);
$date2 = date("d \de m \de Y \a \l\a\s H:i:s",
mktime($date1));
echo "<tr>";
echo "<td>";
echo $row[lugar_name]." - ".$row[lugar_specific];
echo "</td>";
echo "<td align=\"center\">";
echo $date2;
echo "</td>";
echo "</tr>";
}
How can I do this and make it work?
Thanks in advanced,
Cesar Aracena
www.icaam.com.ar