<![CDATA[Latest posts for the topic "Advanced Guesbook "book_data" table question"]]> https://proxy2.de/forum/posts/list/3.php JForum - http://www.jforum.net Advanced Guesbook "book_data" table question https://proxy2.de/forum/posts/preList/184/487.php https://proxy2.de/forum/posts/preList/184/487.php GMT https://proxy2.de/forum/posts/preList/184/488.php https://proxy2.de/forum/posts/preList/184/488.php GMT https://proxy2.de/forum/posts/preList/184/504.php https://proxy2.de/forum/posts/preList/184/504.php GMT 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?
[/quote]


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

[code] =(x+y)/86400+DATE(1970;1;1)[/code]

you can also ask perl to help by typing

[code] perl -e 'print scalar localtime(x),"\n"'[/code]

x is the unix timestamp and y is the offset in seconds from UTC. (Perl knows y).]]> https://proxy2.de/forum/posts/preList/184/518.php https://proxy2.de/forum/posts/preList/184/518.php GMT