Posted by Desert Rider on 10/21/06 17:53

My apologies for the length of this post but I'm hoping that some
background will help clarify my request. I'm not using MySQL for
anything other then the database for my guestbook. I had a previous
guestbook that became corrupted and my new guestbook uses MySQL. I have
access to the database via phpMyAdmin and I can display the entry data
fields.

What I am doing is taking the entries from my previous guestbook and
entering them into the new guestbook. The problem is that the date and
time entry is the current time and date and I want it to be the time
and date of the original entry. When I view the datetime field in
phpMyAdmin the value is listed as a numerical value that, at least to
me, does not correlate to a month, day, year and time value. Example: A
10/20/2006 11:25 pm entry shows up as 1161408341 in the date>value
field in phpMyAdmin.

Is there a correlation table or some sort of formula that I can use to
alter the entered date>value number to the date and time that I want?

MySQL version is 4.1 and phpMyAdmin version is 2.6.4

Thanks for any assistance.

[Back to original message]