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!

Preparing your Splunk Environment for OpenSSL3

The Splunk platform will transition to OpenSSL version 3 in a future release. Actions are required to prepare ...

Unleash Unified Security and Observability with Splunk Cloud Platform

     Now Available on Microsoft AzureThursday, March 27, 2025  |  11AM PST / 2PM EST | Register NowStep boldly ...

Splunk AppDynamics with Cisco Secure Application

Web applications unfortunately present a target rich environment for security vulnerabilities and attacks. ...