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!

Splunk at Cisco Live 2025: Learning, Innovation, and a Little Bit of Mr. Brightside

Pack your bags (and maybe your dancing shoes)—Cisco Live is heading to San Diego, June 8–12, 2025, and Splunk ...

Splunk App Dev Community Updates – What’s New and What’s Next

Welcome to your go-to roundup of everything happening in the Splunk App Dev Community! Whether you're building ...

The Latest Cisco Integrations With Splunk Platform!

Join us for an exciting tech talk where we’ll explore the latest integrations in Cisco + Splunk! We’ve ...