Splunk DBconnect 3.14 timestamp as rising column f...

All Apps and Add-ons

Hello,

I tried to input an DB with query as below:

SELECT ...,
       txn_stamp as TXTIME,

       ....
FROM mybd
WHERE txn_stamp > ? ORDER BY TXTIME ASC

When I hit Excecute query, the result produce error: ORA-01861: literal does not match format string.

My txn_stamp is a time stamp column with the format: YYYY-mm-dd HH:MM:SS (ex: 2023-08-31 00:00:25).

The curious thing is sometime it worked, Executing query show data, but it will stop at some point, I suspect it's because of the above error.

My thinking is I want to formart either my db timestamp formart or the rising column timestamp formart to the same formart so it won't be a mischatch, but I don't know how.

Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Enhance Security Operations with Automated Threat Analysis in the Splunk EcosystemAre you leveraging ...

What Is Splunk? Here’s What You Can Do with Splunk

Hey Splunk Community, we know you know Splunk. You likely leverage its unparalleled ability to ingest, index, ...

Level Up Your .conf25: Splunk Arcade Comes to Boston

With .conf25 right around the corner in Boston, there’s a lot to look forward to — inspiring keynotes, ...