471,049 Members | 1,423 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Porting & converting dates from one DB to another problem

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

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?

- 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:

[} Interiority

Jul 20 '05 #1
0 1184

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Harag | last post: by
8 posts views Thread by tom | last post: by
reply views Thread by Massimo Fiorentino | last post: by
9 posts views Thread by Collin VanDyck | last post: by
2 posts views Thread by Chris | last post: by
2 posts views Thread by bobkolk | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.