View Issue Details

IDProjectCategoryView StatusLast Update
0006578SymmetricDSImprovementpublic2024-09-09 16:00
Reporterjosh-a-hicks Assigned Tojosh-a-hicks  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.9 
Target Version3.15.9Fixed in Version3.15.9 
Summary0006578: SQL Server support for datetime and datetime2 column types when the paramter db.treat.date.time.as.varchar.enabled is true
DescriptionFor SQL Server databases that have a combination of datetime and datetime2 data types the parameter db.treat.date.time.as.varchar.enabled needs enabled. During an initial load though the datetime columns will be selected from the source as Timestamps which have a precision of 9. Then with the conversion to a string based on the parameter setting above it will be too long to load into the target datatime column.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.15 ce9a5873

2024-09-09 15:13:54

joshahicks

Details Diff
0006578: SQL Server support for datetime and datetime2 column types when
the paramter db.treat.date.time.as.varchar.enabled is true
Affected Issues
0006578
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java Diff File

Issue History

Date Modified Username Field Change
2024-09-09 15:13 josh-a-hicks New Issue
2024-09-09 15:13 josh-a-hicks Status new => assigned
2024-09-09 15:13 josh-a-hicks Assigned To => josh-a-hicks
2024-09-09 15:47 josh-a-hicks Status assigned => resolved
2024-09-09 15:47 josh-a-hicks Resolution open => fixed
2024-09-09 15:47 josh-a-hicks Fixed in Version => 3.15.9
2024-09-09 16:00 Changeset attached => SymmetricDS 3.15 ce9a5873
2024-10-01 19:48 admin Status resolved => closed