0003837: MSSQL Support for datetime2 values that are before January 1, 1753 - SymmetricDS

ID	Project	Category	View Status	Date Submitted	Last Update

0003837	SymmetricDS	Improvement	public	2018-12-19 19:49	2024-08-30 17:30

Reporter	josh-a-hicks	Assigned To	josh-a-hicks
Priority	normal
Status	resolved	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 josh-a-hicks 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 josh-a-hicks 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