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.