<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117732#c30">Comment # 30</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117732">bug 117732</a>
from <span class="vcard"><a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> <span class="fn">Robert Großkopf</span></a>
</span></b>
<pre>Here another solution, tested with the database
<a href="https://bugs.documentfoundation.org/attachment.cgi?id=142236">https://bugs.documentfoundation.org/attachment.cgi?id=142236</a>
Add a varchar-field for each date, time or datetimefield:
Dat_dt VARCHAR(19)
Dat_d VARCHAR(10)
Dat_t VARCHAR(8)
Start in Tools → SQL
UPDATE "tst_data" SET "Dat_dt" = LEFT(CAST( "tst_dt" AS VARCHAR ( 30 ) ), 19 ),
"Dat_d" = CAST( "tst_d" AS VARCHAR ( 10 ) ), "Dat_t" = CAST( "tst_t" AS VARCHAR
( 8 ) );
So the dates, times and datetimes will be saved in the HSQLDB as strings, which
wouldn't be changed by migration.
After the migration do start Tools → SQL
UPDATE "tst_data" SET "tst_dt" = "Dat_dt", "tst_d" = "Dat_d", "tst_t" =
"Dat_t";
All fields will be updated to the right date, time or datetime.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>