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