[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 Tamas Bunth changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #30 from Robert Großkopf --- Here another solution, tested with the database https://bugs.documentfoundation.org/attachment.cgi?id=142236 Add a varchar-field for each date, time or datetimefield: Dat_dt VARCHAR(19) Dat_d

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #29 from Alan Wheeler --- I had big problems with migrating dates in my BASE database until I deduced that all dates that had been entered with a value that would have been in UK Daylight Saving Time were out by 1 day after

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 Alex Thurgood changed: What|Removed |Added CC||woodf...@pobox.com --- Comment

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #27 from Drew Jensen --- Opened the RFE here: Migration Assistant: User dialog to set treatment of date and time values during migration https://bugs.documentfoundation.org/show_bug.cgi?id=119675 -- You are receiving this

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #26 from Drew Jensen --- (In reply to Tamas Bunth from comment #25) > (In reply to Drew Jensen from comment #22) > > Does anyone think that the correct way would be to use the current OS TZ > > informtion when the migration

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #25 from Tamas Bunth --- (In reply to Drew Jensen from comment #22) > Does anyone think that the correct way would be to use the current OS TZ > informtion when the migration assistant to change the data so what the user >

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #24 from Terrence Enger --- I have created bug 119625 for the error message of comment 18. -- You are receiving this mail because: You are the assignee for the bug.___

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 Terrence Enger changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #23 from Drew Jensen --- Let me clear up my English deficiency in the comment. When I said it isn't a big deal to change the values I meant that as something done in the Firebird Base environment, if and, after the migration

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #22 from Drew Jensen --- Does anyone think that the correct way would be to use the current OS TZ informtion when the migration assistant to change the data so what the user sees in the Base UI is the same before and after

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #21 from Terrence Enger --- Drew Jensen wrote in comment 10: > As the other issue points out a feature of HSQLdb is to store time > values as the UTC+0 time and accounts (changes) the time > representation supplied from the

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #20 from Julien Nabet --- (In reply to Terrence Enger from comment #19) >... I must recognize I didn't use TZ=UTC, just my locale (France = UTC+1 or +2 depending on the period of the year). I remembered having test every hour

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #19 from Terrence Enger --- Julien Nabet wrote in comment 13: > I don't know how to normalize the retrieved value here. > Adding dateTime.IsUTC = true; or dateTime.IsUTC = false; change > nothing on the results. I am

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process (data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #18 from Terrence Enger --- Comment 14 says that Julien Nabet committed a patch to master. New line 344 or 343 of dbaccess/source/filters/rowinputbinary.cxx reads nHours = (valueInSecs / 3600) + 1; What, I wonder, is

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 Julien Nabet changed: What|Removed |Added Whiteboard|target:6.2.0| --- Comment #17 from Julien

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #16 from Eike Rathke --- Tried a simple conversion with a DATE field, in the same locale (en-US), and (without the patch) 1/2/2019 was changed to 1/31/2019. -- You are receiving this mail because: You are the assignee for

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #15 from Julien Nabet --- Drew/Robert: once the patch is on a daily build, could you provide some feedback? Indeed, a part of the patch (requested by a dev) works but is still a mystery to me. As

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 Commit Notification changed: What|Removed |Added Whiteboard|

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #14 from Commit Notification --- Julien Nabet committed a patch related to this issue. It has been pushed to "master":

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 Julien Nabet changed: What|Removed |Added Priority|medium |high

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #12 from Noel Grandin --- If you look at the hsqldb code we use, inin workdir/UnpackedTarball/hsqldb/ I see a comment in src/org/hsqldb/HsqlDateTime.java HSQLDB uses the client and server's

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #11 from Drew Jensen --- Created attachment 142263 --> https://bugs.documentfoundation.org/attachment.cgi?id=142263=edit draw file with screen shots screen shots of the tables hsqldb / firebird

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #10 from Drew Jensen --- (In reply to Tamas Bunth from comment #8) > This can be related: > > https://bugs.documentfoundation.org/show_bug.cgi?id=63566 Part of it is. So - today I can migrate

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #9 from rob...@familiegrosskopf.de --- (In reply to Tamas Bunth from comment #8) > This can be related: > > https://bugs.documentfoundation.org/show_bug.cgi?id=63566 It is related to datetime and date, but not to the very

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #8 from Tamas Bunth --- This can be related: https://bugs.documentfoundation.org/show_bug.cgi?id=63566 -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #7 from Julien Nabet --- Forget difference part in my previous comment, I checked again, it stays 360 until the end. -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 Julien Nabet changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #5 from Julien Nabet --- Created attachment 142257 --> https://bugs.documentfoundation.org/attachment.cgi?id=142257=edit test each hour, from 00:00 (12AM) to 24:00 (12PM) included I created a brand new

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #4 from rob...@familiegrosskopf.de --- Have had a look to the attached Firebird-file: All dates have been imported correct there - no date has been imported correct here with OpenSUSE 42.3 in Germany Version: 6.0.4.2 Build-ID:

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 rob...@familiegrosskopf.de changed: What|Removed |Added Assignee|rob...@familiegrosskopf.de

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 rob...@familiegrosskopf.de changed: What|Removed |Added Status|UNCONFIRMED |NEW

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 Aron Budea changed: What|Removed |Added Blocks||116968

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #2 from Drew Jensen --- this issue came out of the verification process for a patch applied against https://bugs.documentfoundation.org/show_bug.cgi?id=117298 There is information in the comments

[Libreoffice-bugs] [Bug 117732] Firebird: Migration: Time values are being changed during migration process ( data type TIME and DATETIME)

https://bugs.documentfoundation.org/show_bug.cgi?id=117732 --- Comment #1 from Drew Jensen --- Created attachment 142236 --> https://bugs.documentfoundation.org/attachment.cgi?id=142236=edit zip with input and output of test run -- You are receiving this mail