View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002437 | SymmetricDS | Bug | public | 2015-11-05 15:34 | 2015-11-17 21:02 |
| Reporter | mmichalek | Assigned To | mmichalek | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.7.27 | ||||
| Target Version | 3.7.27 | Fixed in Version | 3.7.27 | ||
| Summary | 0002437: Loading a 'timestamp with time zone' field into a 'timestamp' column appears to mangle the time. | ||||
| Description | The value in question comes across like this: 2015-11-03 01:35:03.714566 -05:00 There are 2 issues right now surrounding AbstractDatabasePlatform.parseDate: 1) The timezone is attempted to be parsed as a code, not offset. 2) The micro second value of 714566 is interpreted as milliseconds instead of microseconds, and that is what makes the resulting date appear to have a mangled time (714566 is interpreted as an absolute number of milliseconds, so almost 12 minutes is added to the time as it appears). | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.7 03d78127 2015-11-05 14:26:21 Details Diff |
0002437: Loading a 'timestamp with time zone' field into a 'timestamp' column appears to mangle the time. |
Affected Issues 0002437 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| add - symmetric-db/src/test/java/org/jumpmind/db/platform/AbstractDatabasePlatformTest.java | Diff File | ||
|
SymmetricDS: master 59f6e1b9 2015-11-05 14:26:21 Details Diff |
0002437: Loading a 'timestamp with time zone' field into a 'timestamp' column appears to mangle the time. |
Affected Issues 0002437 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
| add - symmetric-db/src/test/java/org/jumpmind/db/platform/AbstractDatabasePlatformTest.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-11-05 15:34 | mmichalek | New Issue | |
| 2015-11-05 15:34 | mmichalek | Status | new => assigned |
| 2015-11-05 15:34 | mmichalek | Assigned To | => mmichalek |
| 2015-11-05 19:25 | mmichalek | Summary | Loading a 'timestamp with time zone' field into a 'timezone' column appears to mangle the time. => Loading a 'timestamp with time zone' field into a 'timestamp' column appears to mangle the time. |
| 2015-11-05 19:25 | mmichalek | Description Updated | View Revisions |
| 2015-11-05 19:30 | mmichalek | Status | assigned => resolved |
| 2015-11-05 19:30 | mmichalek | Resolution | open => fixed |
| 2015-11-05 19:30 | mmichalek | Fixed in Version | => 3.7.27 |
| 2015-11-05 20:00 | mmichalek | Changeset attached | => SymmetricDS 3.7 03d78127 |
| 2015-11-05 22:00 | mmichalek | Changeset attached | => SymmetricDS master 59f6e1b9 |
| 2015-11-17 21:02 | chenson | Status | resolved => closed |