Hello there!
I am a bit of a newbee into the mySQL world and I have a question regarding
switching from one DB to another. I have for a couple of years used a very
simple CMS-system created by myself but now I want to move to textpattern
(http://www.textpattern.com/). Using a mySQL tool called NaviCat, I can
easily create queries regarding porting ID, text data etc. from my old DB
into the textpattern DB (using INNER JOINS it seems). But I have one
problem:
The dates I have in my DB is in the format given by PHP by using the
PHP-command time() (Unix-format?), which I have stored as varchar(10)
(Example: 1047756304). But the format Textpattern uses is the DATETIME
format. My question is: How do I port these dates from my DB into the
Textpattern DB?
Additionally:
- Is it possible in the DATETIME format to store time zone information,
since all my dates are in GMT+1?
- And can it all be done in one swoop in either PHP or as a MySQL query?
Thank you for your time!
Yours truly,
Massimo Fiorentino
--
This was a post-paper
communication from:
MASSIMO FIORENTINO (@_º)
[°} Interiority
http://www.interority.com/
ma*****@interiority.com
--