I'm building access definitions between Oracle tables and need to define a relationship between a VARCHAR2 parent column (CHAR_VAL_FK3) and a DATE child column (EFFDT). This produces an error:
"The datatypes are not compatible. CHAR_VAL_FK3 is VARCHAR2(50) and EFFDT is DATE."
I know that child expressions can use SUBSTR and concatenation functions but why no datatype conversion?
Does anyone have any suggestions on how to achieve this?