TO_DATE: A.M. etc. elements do not work without hours, incompatibility with Oracle

SELECT TO_DATE('P.M.','P.M.') AS x;

SELECT TO_DATE('PM','PM') AS x;

SELECT TO_DATE('A.M.','A.M.') AS x;

SELECT TO_DATE('AM','AM') AS x;

SELECT TO_DATE('P.M.','P.M.') AS x;

x

NULL

Warnings:

Warning	1411	Incorrect datetime value: 'P.M.' for function to_date

SELECT TO_DATE('PM','PM') AS x;

x

NULL

Warnings:

Warning	1411	Incorrect datetime value: 'PM' for function to_date

SELECT TO_DATE('A.M.','A.M.') AS x;

x

NULL

Warnings:

Warning	1411	Incorrect datetime value: 'A.M.' for function to_date

SELECT TO_DATE('AM','AM') AS x;

x

NULL

Warnings:

Warning	1411	Incorrect datetime value: 'AM' for function to_date

SELECT TO_DATE('P.M.','P.M.') AS x1;

SELECT TO_DATE('PM','PM') AS x2;

SELECT TO_DATE('A.M.','A.M.') AS x3;

SELECT TO_DATE('AM','AM') AS x4;

X1

01-JAN-26

X2

01-JAN-26

X3

01-JAN-26

X4

01-JAN-26