All Apps and Add-ons

DB Connect error loading a DATE column

responsys_cm
Builder

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?

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What is your SELECT statement?

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...