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!

Get the T-shirt to Prove You Survived Splunk University Bootcamp

As if Splunk University, in Las Vegas, in-person, with three days of bootcamps and labs weren’t enough, now ...

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...