I am making a two server unx using IDT. I need to change this
@catalog(‘FMHP-GHP-EZCAP-DB-CN’).“EZ_FN.dbo”.“CLAIM_BATCHSUMMARY_ALL”.“CREATEDATE” to use something like this
Cast (Convert(DATE , CLAIM_BATCHSUMMARY_ALL.CREATEDATE, 101) as datetime)
I try but I keep getting errors
Tiger_Dan 
(BOB member since 2015-07-07)
Have a look here: DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2
Halfway down the page, I posted several bits of code for dates that work in multi-source IDT. Took me ages to figure out but IDT has its own peculiar syntax so that code works with different databases.
May not help, but might point you in the right direction!
debbie
Debbie 
(BOB member since 2005-03-01)
dear moderator
I am sorry.
But can you or anyone please tell me where I can see some examples
Thanks
Tiger_Dan (BOB member since 2015-07-07)
Dear Tiger_Dan - this is what Debbie meant:
Nick Daniels (BOB member since 2002-08-15)