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
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

.conf25 Global Broadcast: Don’t Miss a Moment

Hello Splunkers, .conf25 is only a click away.  Not able to make it to .conf25 in person? No worries, you can ...

Observe and Secure All Apps with Splunk

 Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What's New in Splunk Observability - August 2025

What's New We are excited to announce the latest enhancements to Splunk Observability Cloud as well as what is ...