If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
Advanced Guesbook "book_data" table question  XML
Forum Index » Support Forum
Author Message
Anonymous



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
Anonymous



INT(11)
Anonymous



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?
Aryan
Beginner
[Avatar]

Joined: 19/01/2002 03:59:07
Messages: 22
Offline

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).
[Email] [ICQ]
 
Forum Index » Support Forum
Go to:   
Based on the open source JForum