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

View solution in original post

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
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!