I am having trouble figuring out the date string format convention for the Denodo VQL TO_DATE function. For the following query:

SELECT COUNT(*) FROM "MPA-Support"."rv_CC0001_LABOR_DATA" WHERE "LABOR_OFF_TS" >= TO_DATE('MM/dd/yyyy hh:mm:ss a', '8/8/2022 12:00:00 AM')

I am getting the error ORA-1830: date format picture ends before converting entire input string.

I believe I have a problem in the date format string but in trying variations on the above I am still not successful. For example, this returns the same error:

SELECT COUNT(*) FROM "MPA-Support"."rv_CC0001_LABOR_DATA" WHERE "LABOR_OFF_TS" >= TO_DATE('M/d/yyyy hh:mm:ss a', '8/8/2022 12:00:00 AM')

I have been trying to follow the documentation at the url below, but it lacks examples and I’m still unclear what my error is.
https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/date_and_time_pattern_strings/date_and_time_pattern_strings