Need more Date examples using multi-source

[system]

Can you tell where to find examples of date funtions, date convertions, when using multi-source data.

for example: I have

@catalog(‘FMHP-GHP-EZCAP-DB-CN’).“EZ_FN.dbo”.“CLAIM_BATCHSUMMARY_ALL”.“CREATEDATE”

and I need to apply this

Cast (Convert(DATE , CLAIM_BATCHSUMMARY_ALL.CREATEDATE, 101) as datetime)

and always I get an error

---

Tiger_Dan (BOB member since 2015-07-07)

[system]

Is this the same question as this? multi server problem using IDT

Debbie

---

Debbie (BOB member since 2005-03-01)

[system]

yes

---

Tiger_Dan (BOB member since 2015-07-07)

[system]

@Tiger_Dan

yes

So why did you create another post?

---

Mak 1 (BOB member since 2005-01-06)

[system]

Moderator note:
Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

Please continue in the original topic here:

multi server problem using IDT

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)

---

Marek Chladny (BOB member since 2003-11-27)