Bug report function to_date should reject HH24:MI:SS formatting options

Hello,

It is very misleading that you can write this :
SELECT * FROM orders WHERE date BETWEEN TO_DATE('2021-09-29 08:30:00', 'YYYY-MM-DD HH24:MI:SS') and TO_DATE('2021-09-30 08:30:37', 'YYYY-MM-DD HH24:MI:SS');

This will ignore the time part and select rows that seem out of range.

TO_DATE function should reject the time part (HH24:MI:SS) in the template string.

I just saw developers coming from Oracle spending a lot of time on this.

Thank you so much for working on this software.

B. R.

Sébastien Caunes