View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003837 | SymmetricDS | Improvement | public | 2018-12-19 19:49 | 2025-05-14 19:08 |
| Reporter | josh-a-hicks | Assigned To | josh-a-hicks | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.9.0 | ||||
| Target Version | 3.9.16 | Fixed in Version | 3.9.16 | ||
| Summary | 0003837: MSSQL Support for datetime2 values that are before January 1, 1753 | ||||
| Description | Timestamp from other dialects are mapped to datetime in MSSQL which will not accept dates before January 1, 1753. In order to support dates loading into MSSQL datetime2 which has a range of 0001-01-01 through 9999-12-31 you need to turn on the following parameter at the MSSQL node. db.treat.date.time.as.varchar.enabled=true | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.10 b5a3c4c8 2018-12-19 14:50:16 Details Diff |
0003837: MSSQL Support for datetime2 values that are before January 1, 1753 |
Affected Issues 0003837 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDmlStatement.java | Diff File | ||
|
SymmetricDS: 3.9 e25d597c 2018-12-19 15:00:32 Details Diff |
0003837: MSSQL Support for datetime2 values that are before January 1, 1753 |
Affected Issues 0003837 |
|
| mod - symmetric-db/src/main/java/org/jumpmind/db/platform/mssql/MsSqlDmlStatement.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-12-19 19:49 | josh-a-hicks | New Issue | |
| 2018-12-19 19:49 | josh-a-hicks | Status | new => assigned |
| 2018-12-19 19:49 | josh-a-hicks | Assigned To | => josh-a-hicks |
| 2018-12-19 20:00 | josh-a-hicks | Changeset attached | => SymmetricDS 3.10 b5a3c4c8 |
| 2018-12-19 21:00 | josh-a-hicks | Changeset attached | => SymmetricDS 3.9 e25d597c |
| 2018-12-27 15:08 | josh-a-hicks | Status | assigned => resolved |
| 2018-12-27 15:08 | josh-a-hicks | Resolution | open => fixed |
| 2018-12-27 15:08 | josh-a-hicks | Fixed in Version | => 3.9.16 |
| 2024-08-30 17:30 | elong | Relationship added | related to 0006572 |
| 2025-05-14 19:08 | elong | Status | resolved => closed |