Hi All,
My below query returns all the results when both the issue_date and effective_date are null but it does not return the records that has date in issue_date and and timestamp in EFFECTIVE_DATE. I'm unable to convert the date to timestamp or timestamp to date in my join below.
I need to see the results when both of these fields are null or both of them has the same date. I'm using Oracle 19C
select * from TABLE-A a
inner join TABLE-B b
on a.issue_date=b.EFFECTIVE_DATE;
TABLE-A:
Column definition: ISSUE_DATE DATE
TABLE-B:
Column definition: EFFECTIVE_DATE TIMESTAMP(6)
