<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Migration Assistant: User dialog to set treatment of date and time values during migration"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119675">119675</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Migration Assistant: User dialog to set treatment of date and time values during migration
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>drewjensen.inbox@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>The migration of date and time values from an HSQLdb data source to a Firebird
data source requires a decision with regards to how to handle the difference
between the two data engines interpretation of these values.
The HSQL RDBMS (servers and client tools) work with an awareness of the users
timezone and use to transform data sent from the client to the server and again
from the server to the client. Transforming the data from client_TZ -> UTC(0)
when sent and from UTC(0) -> Client_TZ when retrieved.
The Firebird RDBMS (servers and client tools) have no such awareness of time
zones, writing whatever the client gives to the server.
Since the migration assistant in LibreOffie is reading directly from the disc
image for the the HSQL data store, with no use of HSQL tools, the value
retrieved is always the value relative to the UTC(0) timezone.
If that value is written as is into the new Firebird data source the users will
see a difference in their data with displayed dates and times adjusting. This
change currently happens automatically.
The RFE is to add during the migration assistant function a dialog which gives
the users the option to move the date as stored or to have the assistant
transform the values from the UTC(0)_TZ value to the users Timezone equivalent
and therefore maintaining the same values presented to the user on screen and
in reports.
For reference see this issue: Firebird: Migration: Time values are being
changed during migration process (data type TIME and DATETIME)
<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="show_bug.cgi?id=117732">https://bugs.documentfoundation.org/show_bug.cgi?id=117732</a></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>