Help!!! How do you display timestamp in a readable format?
Posted: Sun Aug 05, 2007 5:58 pm
Hi,
I have the time and date stored in my mysql database as a timestamp. the problem is when you use echo to display it on the screen it displays the timestamp and not what the timestamp should be converted to. below is the method i am using to echo onto the screen;
How do i convert/format the timestamp to display the the atual date and time and not just the string of numbers timestamp uses?
Many Thanks
jjohall2000
I have the time and date stored in my mysql database as a timestamp. the problem is when you use echo to display it on the screen it displays the timestamp and not what the timestamp should be converted to. below is the method i am using to echo onto the screen;
Code: Select all
<td bgcolor="#FFFFFF"><? echo $rows['time_date']; ?></td>Many Thanks
jjohall2000