[runya]

I need some help with configuring my guestbook which runs on php and mysql. I need to migrate old data from my old guestbook to the current one. The problem i have is the way the dates are saved to the database. For example Wed 23 Jul 2003 14:02:19 EDT is saved as 1058983339.
Thu 24 Jul 2003 10:32:35 EDT is saved as 1059057155.

Thanks in advance.

[ChristGuy]

Greetingz....

Try using the following:

PHP Code:

  echo Date("r", 1059057155); 

On my system this displays Thu, 24 Jul 2003 16:32:35 +0200

So just replace the date display with the one above... and it should work...

[runya]

I am not sure i understand. The dates appear as Thu, 24 Jul 2003 16:32:35 +0200 on the live page allthough the database records 1059057155.

If it is possible i want to change how the data is stored, that is if i can have it stored as Thu, 24 Jul 2003 16:32:35 (as opposed to 1059057155 ) it will be great. If this not possible i want to know how Thu, 24 Jul 2003 16:32:35 gets converted to 1059057155.

[ChristGuy]

Greetingz...

The date is currently stored as a Unix Time stamp... I find them easier to work with as you don't need to convert them for use with Date.

The only other MySQL format you could use would be Date which is in the format YYYY-MM-DD.

for an explanation of PHP Date() go here: http://www.php.net/date

hope this helps...