TO_CHAR Function not working for 12/31/1840 in Cache DB

Question

Meenakshi Shanmugam · Jul 15, 2020

Hi,

Below To_Char function is not working as expected

SELECT TO_CHAR('12/31/1840','mm/dd/yyyy') ---01/12/1841

I expect the result to be 12/31/1840. Let me know If there are any suggestion to get the correct result.

Thanks,
Meena