- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
DB Connect error loading a DATE column
responsys_cm
Builder
11-09-2018
12:55 PM
When I run a SELECT on a SQLite table, some of the columns that have dates in them come back with an error:
failed to load column with type DATE
When I use sqlite3 to read that table, this is what I see in the date fields:
2018-10-12T18:09:00.887-04:00
2018-10-12T18:09:01.353-04:00
2018-10-12T18:09:01.620-04:00
2018-10-12T18:09:01.933-04:00
2018-10-12T18:09:02.370-04:00
2018-10-12T18:09:02.760-04:00
2018-10-12T18:09:03.073-04:00
Those are clearly dates, but I'm not sure if what I think is the trailing offset at the end is messing Splunk up. How do I tell DB Connect how to parse this date correctly?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

richgalloway

SplunkTrust
11-11-2018
07:15 AM
What is your SELECT statement?
---
If this reply helps you, Karma would be appreciated.
If this reply helps you, Karma would be appreciated.
