I want to join to two tables by matching columns (timestamp) with include non-matches for the onepager_HPPO table. The data from second table onepager HPPO_adddata_ONSTS is only present until 08/08/08 10:00 in the joined tables although it should be until end of 2019. The format of two timestamps is identical. What cause this issue or how can it be resolved?
It looks like there might be a bug: I did reproduce your problem even when I forced the date stamp to be in numerical format. The only work around I could find, which is rather ugly, is to extract the HOUR, DAY, MONTH, and YEAR in separate columns for each table and joined based on all 4 values. Maybe somebody else will have more insight. Best, TS