hsql has another time format, so i have 2007-09-23 14:34:00,131 instead of a timestamp in mysql.
how can i get around to get to copy a table with hsql-timestamps to mysql?
(lahr at d-labs dot com)
Logged In: YES
I tried sending this to your email but I'm getting failure to deliver bounce messages. Here is what I sent a couple of days ago (if you want to submit the script(s) you may attach them as files to this ticket):
That sure looks like a timestamp to me (2007-09-23 14:34:00,131).
When I copy a table with TIMESTAMP column in HSQLDB to MySQL, the data
copies just fine. It would be helpful if you could send me a script
that has :
1) Create table for HSQLDB
2) Create table for MySQL (unless DBCopy is creating the table for you)
3) At least one insert statement for the HSQLDB database.
Also, before you send me the script, please run it and verify that you
still see the behavior where the timestamp isn't copied correctly.
What version of MySQL and HSQLDB are you using (Server and JDBC
Tried to get more info a while back on this but the reporter was unreachable. Since I couldn't reproduce the issue, it is now closed.