02-09-2023 01:41 AM
Hi,
I am using Oracle-Select Snap to fetch data from DB. Getting error when i pass date value. UPD_DATE is date value in Oracle.
Error:
“reason”: “SQL [select * from "STVAPP"."TBL_UNITS" where (ID =74341 and TYPE != ‘URM’ and UPD_DATE>‘2019-01-29’) offset 0 rows fetch next ? rows only]; ORA-01861: literal does not match format string\n”,
Thanks