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!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...