Hopefully someone can help with this error I'm getting. The code line is below and the error is "ORA-01849: hour must be between 1 and 12"
REQUEST_DATETIME is a Char field and for an example contains: 08-01-2019 01:30:09am
WHERE TRUNC(TO_DATE(REQUEST_DATETIME,'MM/DD/YYYY HH:MI:SSAM')) = TRUNC(SYSDATE-1)
Thanks so much for your help