Hello all,
I am getting two tables into IDT, one from Oracle and the other from SQL Server.
Issue - When I join using the dates from both tables the results are 0.
Checked with to string, to date , to string to char but doesn’t work.
Did anybody have such issues and can suggest ?
to_date(Column1-SQLServer)=to_date(Column2_Oracle)
Regards,
Venkat
Mjames (BOB member since 2018-05-16)
Where are you joining the tables? If it’s in IDT, you need generic SQL that both SQL and Oracle can use. Have a look at my post here - about half way down for some ideas: DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2
debbie
Debbie 
(BOB member since 2005-03-01)
When using multisource universes, joins and object definitions must* use Multisource SQL, and not the underlying database’s SQL.
With that said, what is the data type of the two date fields? Are they strings, dates, timestamps?
*Sort of… The is a NATIVE EXPRESSION function that does this but is not documented.
joepeters 
(BOB member since 2002-08-29)