Topic
1 reply Latest Post - ‏2013-08-02T20:26:01Z by sundar_chinnagoundan
JohnMcKeever
JohnMcKeever
3 Posts
ACCEPTED ANSWER

Pinned topic Relationships between different datatypes

‏2013-07-29T04:57:09Z |

Hi,

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?

Thanks,

John.