I have an issue when I am loading thd data from the source System (Oracle).
All dates and timestamp format are delivered with the YY Format for the year.
When trying to change the format in Qlikview to DD.MM.YYYY the data are interpret wrong:
e.g. 07.03.10 13;04:00 to 07.03.0110
Should be => 07.03.2010 ...
What I can do to adjust it to the right format?
Haven't worked with Oracle for some time, but you used to be able to get rid of the time part with just Trunc(field).
Still not solved. Very strange behaviour!
In SQL Developer the only way to get the right field for those field is using the RRRR format which means:
RRRR format means 2-digit years in the range
49 are assumed to be in the current century (ie have the same first two digits as the current year), and years given as
99 are assumed to be in the previous century.
But it is not completely right for every cases.
The DWH guys are looking for the issue more deeply.
I will let you know.