All Apps and Add-ons

Splunk DBConnect Date Error

harshavrath
Contributor

Hi,

I have installed Splunk Db-connect & connected to my Oracle DB when i do a select statement I'm getting numbers(not in standard format example # # # # # # # # # #.# # #) instead of the Date that is stored in DB

In my DB the Date is stored as 01-APR-14.

Any Help is Appreciated,

Thanks.

0 Karma
1 Solution

martin_mueller
SplunkTrust
SplunkTrust

Based on your 10.3 digits I'm going to guess that you're getting an epoch timestamp with millisecond granularity.

http://en.wikipedia.org/wiki/Unix_epoch

View solution in original post

martin_mueller
SplunkTrust
SplunkTrust

Based on your 10.3 digits I'm going to guess that you're getting an epoch timestamp with millisecond granularity.

http://en.wikipedia.org/wiki/Unix_epoch

harshavrath
Contributor

its working,thanks.

0 Karma

harshavrath
Contributor

the data-type is date in my Oracle-DB

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

You could format the date in the SQL query as needed, or use Splunk's SPL to format the date at the end like this: ... | fieldformat date_field=strftime(date_field, "%Y-%m-%d %H:%M:%S")

What's the column's data type in your Oracle DB?

0 Karma

harshavrath
Contributor

how I'm i supposed to handle this epoch time, so that when i query the DB i should get the Date in proper format.

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 ...