Advanced Guesbook "book_data" table question

I need someone to tell what format the date column in ths database table "book_data" is in. I have a previous guestbook installed and the date was a mysql timestamp column. I took this data and imported ti fine except for the date column. I need help with this part because I don know what format the date is in the table "book_data" . Thanks

INT(11)

Thanks for the reply. I know this part but is it something like a unix time stamp. The "date" data that I am trying to input from my old guestbook is in the mysql timestamp format but I dont believe the "date" field on this database is?

hoshea wrote:
Thanks for the reply. I know this part but is it something like a unix time stamp. The "date" data that I am trying to input from my old guestbook is in the mysql timestamp format but I dont believe the "date" field on this database is?

This timestamp may be converted in EXCEL by using the following formula:

you can also ask perl to help by typing

x is the unix timestamp and y is the offset in seconds from UTC. (Perl knows y).