Splunk Search

DBQuery and epoch

ericrobinson
Path Finder

I am creating a dashboard form that is driven off of a text box, and a drop-down. I am trying to dynamically populate the dropdown with the valid date choices for reporting as stored in the DB. The problem is the date is a string in the DB I am querying (20,120,331). NO problem I thought.. I will use the TO_DATE oracle function. Now, the date is showing in Epoch in splunk UI (1333166400). Anyone have any idea on how to make this display correctly?

--I already tried convert - convert timeformat="%H:%M:%S" ctime(time)--

Tags (2)
0 Karma

ericrobinson
Path Finder

User error.. I wasnt displaying the formatted field correctly.

0 Karma
Get Updates on the Splunk Community!

Transforming Financial Data into Fraud Intelligence

Every day, banks and financial companies handle millions of transactions, logins, and customer interactions ...

How to send events & findings from AWS to Splunk using Amazon EventBridge

Amazon EventBridge is a serverless service that uses events to connect application components together, making ...

Exciting News: The AppDynamics Community Joins Splunk!

Hello Splunkers,   I’d like to introduce myself—I’m Ryan, the former AppDynamics Community Manager, and I’m ...