I have an AS/400 database to which I connect using the 5250 or DBeaver, when it was created more than 40 years ago, a field called BIRTHDT was created with the format YYMMDD meaning when I run the query
SELECT name, birthdt, varchar_format(timestamp_format(birthdt,'YYMMDD'),'DD/MM/YYYY') AS Birthdate FROM QS36F.Table
I get for 840212 the value 12/02/2084, so this person will be born in 2084, any way to fix it?