Splunk DBconnect 3.14 timestamp as rising column failed as ORA-01861: literal does not match format string

[tungpx]

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.