This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Incorta Community
- Product
- Product Ideas
- Incorta Spark SQL should be able to replicate MS S...
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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.
