View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001550 | SymmetricDS | Bug | public | 2014-01-30 13:38 | 2014-02-05 15:08 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.5.0 | ||||
| Target Version | 3.5.16 | Fixed in Version | 3.5.16 | ||
| Summary | 0001550: Sybase ASE : Lost precision from Datetime fields | ||||
| Description | On Sybase ASE, datetime fields are being synced with date and time down to seconds, but it is missing the milliseconds. The dialect is using the following function for the time portion: convert(varchar, column, 108) Instead, it should do the following: right('00'+convert(varchar, datepart(HOUR,column)),2)+':' +right('00'+convert(varchar, datepart(MINUTE,column)),2)+':' +right('00'+convert(varchar, datepart(SECOND,column)),2)+'.' +right('000'+convert(varchar, datepart(MILLISECOND,column)),3) | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: master e5ec8c98 2014-01-30 14:48:46 erilong Details Diff |
0001550: Sybase ASE : Lost precision from Datetime fields |
Affected Issues 0001550 |
|
| mod - symmetric-assemble/src/docbook/databases.xml | Diff File | ||
| mod - symmetric-client/src/main/java/org/jumpmind/symmetric/db/ase/AseTriggerTemplate.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-01-30 13:38 | elong | New Issue | |
| 2014-01-30 13:38 | elong | Status | new => assigned |
| 2014-01-30 13:38 | elong | Assigned To | => elong |
| 2014-01-30 17:57 | elong | Description Updated | View Revisions |
| 2014-01-30 19:49 | elong | Status | assigned => resolved |
| 2014-01-30 19:49 | elong | Fixed in Version | => 3.5.16 |
| 2014-01-30 19:49 | elong | Resolution | open => fixed |
| 2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r7899 | |
| 2014-02-05 15:08 | chenson | Status | resolved => closed |
| 2015-07-31 01:49 | Changeset attached | => SymmetricDS master e5ec8c98 |