Thanks Tom, but using only the strtotime() and later the date() functions, the page throus the following error:
Warning: unexpected error in date() in e:\wwwroot\videoteca\index.php on line 52 Now my code looks like this: $date1 = strtotime($row[lugar_lastinsert]); $date2 = date("d \de m \de Y H:i:s", $date1); Any ideas? Thanks, Cesar Aracena www.icaam.com.ar -----Mensaje original----- De: Tom Rogers [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 18 de Septiembre de 2003 01:48 a.m. Para: Cesar Aracena CC: [EMAIL PROTECTED] Asunto: Re: [PHP] MySQL timestamp to desired date function Hi, Thursday, September 18, 2003, 2:38:50 PM, you wrote: CA> Hi all, CA> I have a a timestamp in a DB (14 digits) that I want to display like I CA> want in my pages. I tried to use strtotime, mktime and date functions CA> with no success... it always return the current timestamp instead of the CA> one I have stored. This is what I've done so far: CA> for ($x = 0; $x < $num_rows; $x++) CA> { CA> $row = mysql_fetch_array($result); CA> $date1 = strtotime($row[lugar_lastinsert]); CA> $date2 = date("d \de m \de Y \a \l\a\s H:i:s", CA> mktime($date1)); CA> echo "<tr>"; CA> echo "<td>"; CA> echo $row[lugar_name]." - ".$row[lugar_specific]; CA> echo "</td>"; CA> echo "<td align=\"center\">"; CA> echo $date2; CA> echo "</td>"; CA> echo "</tr>"; CA> } CA> How can I do this and make it work? CA> Thanks in advanced, CA> Cesar Aracena CA> www.icaam.com.ar strtotime() returns a timestamp so you don't need the mktime() call $date2 = date("d \de m \de Y \a \l\a\s H:i:s", $date1); -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php