What is the difference between ‘YYYY-MM-DD HH24:MI:SS’ and ‘YYYY-MM-DD HH:MI:SS’
When source time-stamp is HH24 then Hour of day is (00-23)
When source time-stamp is HH12 or HH then Hour of day (01-12)
While conversion make sure you use the right time-stamp for conversion:
for example if your are trying to convert ‘2016-07-23 00:05:01′ as follows
TO_DATE(2016-07-23 00:05:01,’YYYY-MM-DD HH:MI:SS’) then it will through an error.
the right syntax is replace HH with HH24