mbrack
Ranger
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
05-25-2023
05:37 AM
Status:
New
MS SQL Datetime2(7) Appears as a timestamp in this format: YYYY-MM-DD hh:mm:ss.mmmmmmm
Incorta Spark SQL is truncating this to YYYY-MM-DD hh:mm:ss.mmm.
This causes issues in transactional data where a wider precision level is needed to accurately reflect or pick up the proper record for a transaction on a between join clause. The truncated value that incorta uses can cause duplicates in data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
