3 Replies Latest reply on Mar 12, 2017 8:12 PM by Ross Moffitt

    Custom SQL - DB2 and Oracle - Unable to Join on Date (Red !)

    Ross Moffitt

      I have version 10.1


      Using Custom SQL to query DB2, and another Custom SQL to query Oracle. Both datasets have a record to join on and also a date to join on.


      I can get the record to join, but I have been unsuccessful trying to join on the date field.  I have tried to edit my SQL using casting and varchar conversion to multiple formats, but it doesn't seem to work.


      Any suggestions on how to join on a date from DB2 and Oracle? I get the red ! when I try to join on date.