Casting dates on denodo oracle database gives a different formatting

Question

I have a date column and I am trying to cast this into a view with a code below but the output does not match the requirement. I use denodo and oracle 18g as my database.

Column

  A 

1-Dec-20
12-Dec-20
11-Dec-20

Expected output

  A 

1-Dec-20
12-Dec-20
11-Dec-20

output I am getting after running the code below.

select 
to_localdate('dd-MM-yyyy', substring(replace("A", 'NULL', ''), 0, 10)) AS A from "xxtable"

   A
0020-12-01
0020-12-12
0020-12-11

question from:https://stackoverflow.com/questions/65935422/casting-dates-on-denodo-oracle-database-gives-a-different-formatting

Answer 1

I was able to solve this by using yy instead of yyyy format.

to_localdate('dd-MM-yy', substring(replace("A", 'NULL', ''), 0, 10)) AS A from "xxtable"