All Apps and Add-ons

How do I configure time format in Splunk DB Connect? It's not uploading data

lucasbarbosa
Explorer

I use DBConnect3, and I have a date field in epoch format (Sample below).
When you select it as a timestamp, it shows a configuration option the format.
I am using the format %s, I've also tried the format s (As suggested in the caption).
But in doing so, Splunk is not recognizing the timestamp and as a consequence not uploading the data

How to fix this?

Sample epoch date: 1498892320

alt text

kundeng
Path Finder

This is not cool, now I have to do this.

SELECT TO_TIMESTAMP('1970-01-01 00:00:00.0'
,'YYYY-MM-DD HH24:MI:SS.FF'
) + NUMTODSINTERVAL(r.TIMESTAMPfield, 'SECOND') AS event_date, r.* FROM r where ID> ? ORDER by ID

0 Karma
Get Updates on the Splunk Community!

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...

Splunk App Developers | .conf25 Recap & What’s Next

If you stopped by the Builder Bar at .conf25 this year, thank you! The retro tech beer garden vibes were ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...