Skip to Content
0
Former Member
Aug 22, 2014 at 09:41 PM

Analytic View join issue between TIMESTAMP and DATE formats

36 Views

I have a fact table in my data foundation that has a TIMESTAMP date that i am trying to join with to my calendar table that has a DATE format . I am unable to query this view after creating it and it appears to be because of the data type differences. Is there a way to convert when joining? i can not seem to find a way to do this