To_date 'MM/DD/YYYY HH24:MI:SS' mask unsuported

[sda]

fyi
it seems the ‘MM/DD/YYYY HH24:MI:SS’ is not supported in reference to

Itgensql071 to_date with unsuported format version DD/MM/YYYY HH24:MI:SS

It seems that to_date as evolved and there are missing formats. Try : select to_date('12/11/2020 10:15:33','DD/MM/YYYY HH24:MI:SS') It returns: itgensql071 Unsupported format mask 'DD/MM/YYYY HH24:MI:SS [itgensql071 Unsupported format mask error] but the date mask is documented in Invantive SQL grammar [SQL grammar]

select to_date('01/08/2024 11:02:19', 'MM/DD/YYYY HH24:MI:SS')