join on date and timestamp field
I would like to join 2 tables in a view but the datetypes are data and timestamp (postgreSQL database). Normally I would join these using <timestamp field>::date format so I have 2 fields of the same datatype.
Is it somehow possible to replicate that in YellowFin? I know that I can do a virtual table where I join the 2 but there are more tables involved. Some more flexibility in that area might be nice to have to work around these kind of issue's.
I understand that it is partially caused by inconsequent data but that is not uncommon out there :-).